semvec/pypi-packages huggingface dataset:
myetl 0.1.6
Command line ETL tool
License: Apache-2.0
Requires Python: >=3.8,<4.0

# myetl

Utility to quickly transform CSV and Excel files using SQL. Execute it in a directory containing an **'extracts'** folder  
with *'.xlsx'* and/or *'.csv'* files and a **'transforms'** folder with *'.sql'* files. Select from any file,  
extract or transform, like you would from a table using the filename as the table name. All transforms that do not have  
any other transforms selecting from them will be exported to an 'output' directory as either CSV or Excel files.  
Use --format csv/excel to choose, defaults to csv.  See the examples folder for a basic example.  
The 'output' folder does not have to be present, it will be created by the script. 

Uses SQLite, so only SQLite supported syntax can be used.