PRQL - Query language

home terminal newspaper edit

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

#147on PLDB

2Years Old

Download source code:

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

Homepage · REPL · Source Code · Blog · Twitter · FAQ · Docs

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

Tags: queryLanguage
PRQL is developed on GitHub and has 9,667 stars
Early development of PRQL happened in https://github.com/PRQL
PRQL compiles to SQL
PRQL is written in Rust, Markdown, YAML, TOML, HTML, JavaScript, JSON, CSS, CSV, C#, PHP, Elixir, TypeScript, JSX, Bourne shell, Python, Java, Zig, Make, Dockerfile, XML, SQL, Nix, C, C++, Handlebars, SVG
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`).

Language features

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