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
pyprqlwithout 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
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 details)
Built Distribution
pyprql-0.5.0-py3-none-any.whl
(22.0 kB
view details)
File details
Details for the file pyprql-0.5.0.tar.gz.
File metadata
- Download URL: pyprql-0.5.0.tar.gz
- Upload date:
- Size: 20.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.8.0 pkginfo/1.8.2 readme-renderer/35.0 requests/2.27.1 requests-toolbelt/0.9.1 urllib3/1.26.9 tqdm/4.64.0 importlib-metadata/4.11.3 keyring/23.5.0 rfc3986/2.0.0 colorama/0.4.4 CPython/3.9.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | e819d2432f44cbf969dc4dd923fdc7fe8c80123c46fc3f78e7ceec2b1e6f801f |
|
| MD5 | c5d2e21e13d335b0db4b707e6c9d7500 |
|
| BLAKE2b-256 | 356cea7561753a76df8dca647668993a54103df2bae2e96c71486bc3d38a7c52 |
Provenance
File details
Details for the file pyprql-0.5.0-py3-none-any.whl.
File metadata
- Download URL: pyprql-0.5.0-py3-none-any.whl
- Upload date:
- Size: 22.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.8.0 pkginfo/1.8.2 readme-renderer/35.0 requests/2.27.1 requests-toolbelt/0.9.1 urllib3/1.26.9 tqdm/4.64.0 importlib-metadata/4.11.3 keyring/23.5.0 rfc3986/2.0.0 colorama/0.4.4 CPython/3.9.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | da57bd723ae91babf219924cb56ff4e3743422c0f39d5ada6bac96e5685c0d6d |
|
| MD5 | 1f7b702cb01215a78d1dd6c5db3a6071 |
|
| BLAKE2b-256 | 29d8d8a5fd378748fbadfdd5addd8c337fb5eef1564ef8eafe4f2939cfd1eef1 |
