1.
Introduction
2.
Queries
2.1.
Pipelines
2.2.
Functions
2.3.
Variables
3.
Transforms
3.1.
Aggregate
3.2.
Append
3.3.
Derive
3.4.
Filter
3.5.
From
3.6.
From Text
3.7.
Group
3.8.
Join
3.9.
Select
3.10.
Sort
3.11.
Take
3.12.
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.
Standard library
5.7.1.
From text
5.7.2.
Loop
5.8.
Strings
5.9.
S-strings
5.10.
F-strings
5.11.
Case
5.12.
Target & Version
6.
Bindings
6.1.
.NET
6.2.
Elixir
6.3.
Java
6.4.
JavaScript
6.5.
Python
6.6.
R
6.7.
Rust
7.
Integrations
7.1.
dbt
7.2.
Jupyter
7.3.
DuckDB
7.4.
Prefect
7.5.
VS Code
7.6.
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.
Developing with Docker
9.3.
Developing with Dev Containers
10.
Internals
10.1.
Compiler architecture
10.2.
Helpers
10.3.
Name resolving
10.4.
Functions
10.5.
Syntax highlighting
Light
Rust
Coal
Navy
Ayu
PRQL language book
From Text