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.
Group
3.7.
Join
3.8.
Select
3.9.
Sort
3.10.
Take
3.11.
Window
4.
Syntax
4.1.
Pipes
4.2.
Lists
4.3.
Expressions & Operators
4.4.
Inner Transforms
4.5.
Comments
4.6.
Quoted Identifiers
4.7.
Parameters
4.8.
Numbers
4.9.
Keywords
5.
Language features
5.1.
Case
5.2.
Coalesce
5.3.
Dates & times
5.4.
Distinct
5.5.
Null handling
5.6.
Ranges
5.7.
Regex
5.8.
Standard library
5.8.1.
From_text
5.8.2.
Loop
5.8.3.
Reading files
5.9.
Strings
5.10.
S-strings
5.11.
F-strings
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
11.
Changelog
Light
Rust
Coal
Navy
Ayu
PRQL language book
Helpers
Cheat sheets for
prqlc
are available on various websites and with various tools.
tldr
(
on the web
)
eg