- 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