Skip to main content

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


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.5.tar.gz (18.7 kB view details)

Uploaded Source

Built Distribution

pyprql-0.2.5-py3-none-any.whl (20.0 kB view details)

Uploaded Python 3

File details

Details for the file pyprql-0.2.5.tar.gz.

File metadata

  • Download URL: pyprql-0.2.5.tar.gz
  • Upload date:
  • Size: 18.7 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.1 importlib-metadata/4.11.3 keyring/23.5.0 rfc3986/2.0.0 colorama/0.4.4 CPython/3.9.10

File hashes

Hashes for pyprql-0.2.5.tar.gz
Algorithm Hash digest
SHA256 6e0974b3b811de2a99858aca85971326355556f38339e03ca80b615042b745a4
MD5 0c3a6a0995787ccb227a12d8d015aff4
BLAKE2b-256 32bf9b0e79ba98b764e2efd07da1a9bb3054edb952d0ca82dd2ac551f748be81

See more details on using hashes here.

Provenance

File details

Details for the file pyprql-0.2.5-py3-none-any.whl.

File metadata

  • Download URL: pyprql-0.2.5-py3-none-any.whl
  • Upload date:
  • Size: 20.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.1 importlib-metadata/4.11.3 keyring/23.5.0 rfc3986/2.0.0 colorama/0.4.4 CPython/3.9.10

File hashes

Hashes for pyprql-0.2.5-py3-none-any.whl
Algorithm Hash digest
SHA256 39a2ffe830388c76712ab95f520db50add8cef7783658bd144b8ffa6edb49ce0
MD5 5b7c50f9f23be73fe99e750626fd6a73
BLAKE2b-256 9c03d720851f49142a9c34d2abdce84e03ad33650bfd4e828b9d4169866b7b2a

See more details on using hashes here.

Provenance

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