Python Implementation of Pipelined Relational Query Language (PRQL)
Project description
PyPrql
Python implementation of PRQL.
Documentation of PRQL is at https://github.com/max-sixty/prql
Installation
pip install pyprql
CLI
Usage:
pyprql 'connection_string'
pyprql 'postgresql://user:password@localhost:5432/database'
Examples:
pyprql 'sqlite:///chinook.db'
Try it out:
curl https://github.com/qorrect/PyPrql/blob/main/resources/chinook.db?raw=true -o chinook.db
pyprql "sqlite:///chinook.db"
PRQL> show tables
pyprql.to_sql
query='''
from employees
filter country = "USA"
derive [
gross_salary: salary + payroll_tax,
gross_cost: gross_salary + benefits_cost
]
filter gross_cost > 0
aggregate by:[title, country] [
average salary,
sum salary,
average gross_salary,
sum gross_salary,
average gross_cost,
sum_gross_cost: sum gross_cost,
row_count: count salary
]
sort sum_gross_cost
filter row_count > 200
take 20
'''
from pyprql import to_sql
sql = to_sql(query)
print(sql)
SELECT AVG(salary),
SUM(salary),
AVG(salary + payroll_tax),
SUM(salary + payroll_tax),
AVG(salary + payroll_tax + benefits_cost),
SUM(salary + payroll_tax + benefits_cost) as sum_gross_cost,
COUNT(salary) as row_count,
salary + payroll_tax as gross_salary,
(salary + payroll_tax) + benefits_cost as gross_cost
FROM `employees` employees_e
WHERE country="USA" AND (gross_salary+benefits_cost)>0
GROUP BY title, country
HAVING row_count >200
ORDER BY sum_gross_cost
LIMIT 20
Differences from the spec
The parser is only able to parse casts in select statements insde of [ ]
, so
select foo | as float
will fail, it must be wrapped in brackets as a single item list.
select [ foo | as float ]
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.2.1.tar.gz
(18.1 kB
view details)
Built Distribution
pyprql-0.2.1-py3-none-any.whl
(19.0 kB
view details)
File details
Details for the file pyprql-0.2.1.tar.gz
.
File metadata
- Download URL: pyprql-0.2.1.tar.gz
- Upload date:
- Size: 18.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.8.0 pkginfo/1.8.2 readme-renderer/34.0 requests/2.27.1 requests-toolbelt/0.9.1 urllib3/1.26.9 tqdm/4.63.0 importlib-metadata/4.11.3 keyring/23.5.0 rfc3986/2.0.0 colorama/0.4.4 CPython/3.9.10
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4f32d6f36e207f1cf9cde943cdd7a02937a67ba750dd8544d90de6ef87b8daa1 |
|
MD5 | 496ca10981f7b2e707a3a0a252a874f9 |
|
BLAKE2b-256 | 94f6eb2a06463354a2b59cb8a5b47ac5c4ffb60c9e54f15d885681c275e52f8b |
File details
Details for the file pyprql-0.2.1-py3-none-any.whl
.
File metadata
- Download URL: pyprql-0.2.1-py3-none-any.whl
- Upload date:
- Size: 19.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.8.0 pkginfo/1.8.2 readme-renderer/34.0 requests/2.27.1 requests-toolbelt/0.9.1 urllib3/1.26.9 tqdm/4.63.0 importlib-metadata/4.11.3 keyring/23.5.0 rfc3986/2.0.0 colorama/0.4.4 CPython/3.9.10
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 12d13f50527d3d96d4c7cf9aa83d1e0555d127e82fa1f0239062fddc4e7f23f3 |
|
MD5 | 1debb4d3bfb66d6bcc75f7579a923b2d |
|
BLAKE2b-256 | b1cea1970db969bc1b2231ad526773ce94c1147e950c164f2987b6321df80634 |