Introduction
Tutorial
1.
Relations
2.
Filtering
3.
Aggregation
Reference
4.
Syntax
4.1.
Literals
4.2.
Strings
4.2.1.
F-strings
4.2.2.
R-strings
4.2.3.
S-strings
4.3.
Tuples
4.4.
Arrays
4.5.
Identifiers & keywords
4.6.
Function calls
4.7.
Pipes
4.8.
Operators
4.9.
Case
4.10.
Ranges
4.11.
Comments
4.12.
Parameters
5.
Importing data
5.1.
From
5.2.
Reading files
5.3.
Ad-hoc data
6.
Declarations
6.1.
Variables — let & into
6.2.
Functions
7.
Standard library
7.1.
Transforms
7.1.1.
Aggregate
7.1.2.
Append
7.1.3.
Derive
7.1.4.
Filter
7.1.5.
Group
7.1.6.
Join
7.1.7.
Loop
7.1.8.
Select
7.1.9.
Sort
7.1.10.
Take
7.1.11.
Window
7.2.
Aggregation functions
7.3.
Date functions
7.4.
Mathematical functions
7.5.
Text functions
7.6.
Removing duplicates
8.
Specification
8.1.
Null handling
8.2.
Name resolution
8.3.
Modules
8.4.
Type system
Project
9.
Changelog
10.
Target & version
11.
Bindings
11.1.
.NET
11.2.
Elixir
11.3.
Java
11.4.
JavaScript
11.5.
PHP
11.6.
Python
11.7.
R
11.8.
Rust
12.
Integrations
12.1.
prqlc CLI
12.2.
ClickHouse
12.3.
Jupyter
12.4.
DuckDB
12.5.
qStudio
12.6.
Prefect
12.7.
VS Code
12.8.
PostgreSQL
12.9.
Databend
12.10.
Rill
12.11.
Syntax highlighting
13.
Contributing to PRQL
13.1.
Development
13.2.
Language design
Light
Rust
Coal
Navy
Ayu
PRQL language book
ClickHouse
PRQL works natively in ClickHouse. Check out the
ClickHouse docs
for more details.