1.
Introduction
2.
Queries
2.1.
Pipelines
2.2.
Functions
2.3.
Tables
3.
Transforms
3.1.
Aggregate
3.2.
Append
3.3.
Derive
3.4.
Filter
3.5.
From
3.6.
Group
3.7.
Join
3.8.
Select
3.9.
Sort
3.10.
Take
3.11.
Window
4.
Syntax
5.
Language features
5.1.
Coalesce
5.2.
Dates & times
5.3.
Distinct
5.4.
Null handling
5.5.
Ranges
5.6.
Regex
5.7.
Stdlib
5.8.
Strings
5.9.
S-Strings
5.10.
F-Strings
5.11.
Switch
5.12.
Target & Version
6.
Bindings
6.1.
Elixir
6.2.
Java
6.3.
JavaScript
6.4.
Python
6.5.
R
6.6.
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.
Employees
9.
Contributing to PRQL
9.1.
Development
9.2.
Using Docker
10.
Internals
10.1.
Compiler architecture
10.2.
Name resolving
10.3.
Functions
10.4.
Syntax highlighting
Light
Rust
Coal
Navy
Ayu
PRQL Language Book
Integrations
PRQL is building integrations with lots of external tools, including:
dbt
Jupyter
Prefect
VSCode
Rill