PRQL

home code edit

PRQL, aka Pipelined Relational Query Language, is a query language created in 2022 by Maximilian Roos.

Source code:

git clone https://github.com/prql/prql

#361on PLDB

2Years Old

PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement

PRQL website
PRQL is developed on GitHub and has 4,261 stars
PRQL first developed in https://github.com/PRQL
PRQL compiles to SQL
prql-lang.org was registered in 2022
Read more about PRQL on the web: 1. 2.

Example from the web:

from employees
filter country == "USA"                       # Each line transforms the previous result.
aggregate [                                   # `aggregate` reduces column to a value.
  max salary,
  min salary,
  count,                                      # Closing commas are allowed :)
]

Example from the web:

from employees
filter start_date > @2021-01-01               # Clear date syntax.
derive [                                      # `derive` adds columns / variables.
  gross_salary = salary + (tax ?? 0),         # Terse coalesce
  gross_cost = gross_salary + benefits_cost,  # Variables can use other variables.
]
filter gross_cost > 0
group [title, country] (                      # `group` runs a pipeline over each group.
  aggregate [                                 # `aggregate` reduces each group to a row.
    average gross_salary,
    sum_gross_cost = sum gross_cost,          # `=` sets a column name.
  ]
)
filter sum_gross_cost > 100000                # Identical syntax for SQL's `WHERE` & `HAVING`.
derive id = f"{title}_{country}"              # F-strings like python.
sort [sum_gross_cost, -country]               # `-country` means descending order.
take 1..20                                    # Range expressions (also valid here as `take 20`).

Feature	Supported	Token	Example
Comments	✓		# A comment
Line Comments	✓	#	# A comment
Semantic Indentation	X

PRQL - Query language

Language features