Last updated:
0 purchases
prqlpython 0.11.2
prql-python
prql-python offers Rust bindings to the prql-compiler Rust library. It
exposes a Python method compile(query: str) -> str.
This is consumed by pyprql &
dbt-prql.
The crate is not published to crates.io; only to PyPI at
https://pypi.org/project/prql-python/.
Installation
pip install prql-python
Usage
import prql_python as prql
prql_query = """
from employees
join salaries (==emp_id)
group {employees.dept_id, employees.gender} (
aggregate {
avg_salary = average salaries.salary
}
)
"""
options = prql.CompileOptions(
format=True, signature_comment=True, target="sql.postgres"
)
sql = prql.compile(prql_query)
sql_postgres = prql.compile(prql_query, options)
Relies on pyo3 for all the magic.
For personal and professional use. You cannot resell or redistribute these repositories in their original state.
There are no reviews.