Python Implementation of Pipelined Relational Query Language (PRQL)
Project description
PyPrql
Python bindings to PRQL.
For docs, Check out the PyPRQL Docs, and the PRQL Book.
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.1.tar.gz
(20.6 kB
view hashes)
Built Distribution
pyprql-0.5.1-py3-none-any.whl
(22.7 kB
view hashes)