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
Bindings
PRQL has bindings for many languages. These include:
Java
JavaScript
Python
R
Rust
Elixir