1.
Introduction
2.
Queries
2.1.
Pipelines
2.2.
Functions
2.3.
Tables
2.4.
Syntax
2.5.
Dialect & Version
3.
Transforms
3.1.
Aggregate
3.2.
Derive
3.3.
Filter
3.4.
From
3.5.
Group
3.6.
Join
3.7.
Select
3.8.
Sort
3.9.
Take
3.10.
Window
4.
Language features
4.1.
Coalesce
4.2.
Dates & Times
4.3.
Distinct
4.4.
F-Strings
4.5.
Null handling
4.6.
Ranges
4.7.
Regex
4.8.
S-Strings
4.9.
Strings
5.
Stdlib
6.
Bindings
6.1.
Java
6.2.
JavaScript
6.3.
Python
6.4.
Rust
7.
Integrations
7.1.
dbt
7.2.
Jupyter
7.3.
Prefect
7.4.
VSCode
7.5.
Rill
8.
Examples
8.1.
Variables
8.2.
List equivalence
8.3.
CTE (intermediate tables)
8.4.
SQL parameters
8.5.
Employees
Light (default)
Rust
Coal
Navy
Ayu
PRQL Language Book
Integrations