Python (prql-python)

Installation

pip install prql-python

Usage

1. import prql_python as prql

3. prql_query = """
4. from employees
5. join salaries [==emp_id]
6. group [dept_id, gender] (
7. aggregate [
8. avg_salary = average salary
9. ]
10. )
11. """

13. sql = prql.compile(prql_query)