CLI to conveniently run DuckDB SQL scripts with support for templating
Project description
# Qck 🦆👩💻
Qck (pronounced “quack”) is a CLI script to conveniently run [DuckDB](https://duckdb.org/) SQL scripts with support for [Jina](https://jinja.palletsprojects.com/) templating.
## 🛠️ Installation
Use pip install qck to install. This will make available the qck script.
## 🚀 Usage
Run qck –help to view the built-in documentation.
Running qck with just a SQL file will execute the query and print the results to the terminal:
`bash qck myquery.sql `
You can also LIMIT the number of rows in the output by adding a flag:
`bash qck myquery.sql --limit 10 # will only print 10 rows `
To execute a query and write the result to a Parquet file, use –to-parquet:
`bash qck myquery.sql --to-parquet myresult.parquet `
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.