qck 2024.1.31

CLI to conveniently run DuckDB SQL scripts with support for templating

# 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 `