Python Implementation of Pipelined Relational Query Language (PRQL)
Project description
PyPrql
Python bindings to PRQL. Documentation of PRQL is here.
This project is maintained by @qorrect and @rbpatt2019
Installation
pip install pyprql
Try it out
Database
curl https://github.com/qorrect/PyPrql/blob/main/resources/chinook.db?raw=true -o chinook.db
pyprql "sqlite:///chinook.db"
PRQL> show tables
CSV file
curl https://people.sc.fsu.edu/~jburkardt/data/csv/zillow.csv
pyprql zillow.csv
The pyprql tool
- pyprql can connect to any database that SQLAlchemy supports, execute
pyprql
without arguments for docs on how to install drivers. - pyprql can connect to CSV files, replace the connection string with the file path and it will load the CSV into a temporary SQLite database.
- pyprql can save the results with a
| to csv ${filename}
transform at the end of the query - pyprql has auto-completion on table names and table aliases with tab, and history-completion with alt-f
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pyprql-0.5.0.tar.gz
(20.0 kB
view hashes)
Built Distribution
pyprql-0.5.0-py3-none-any.whl
(22.0 kB
view hashes)