Skip to main content

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 `

The default is to LIMIT the output to 100 lines. You can override this with the –limit option:

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

You can also call qck from within Python:

`python from qck import qck rs = qck("myquery.sql") rs.to_parquet("myresult.parquet") `

For a full list of arguments to qck, please refer to the [source](qck.py).

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

qck-2024.3.20.tar.gz (4.0 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page