DuckDB DuckDB There’s an experimental DuckDB extension from @ywelsch at ywelsch/duckdb-prql . Check out the Readme for more details.

DuckDB DuckDB There’s an experimental DuckDB extension from @ywelsch at ywelsch/duckdb-prql . Check out the Readme for more details.

Filtering rows filter transform take transform Filtering rows In the previous page we learned how select , derive , and join change the columns of a table. Now we will expl...

Filtering rows filter transform take transform Filtering rows In the previous page we learned how select , derive , and join change the columns of a table. Now we will expl...

Regex expressions Regex expressions Note At this time, PRQL does not have a facility for regular expression (regex) processing. The Milestone for 0.5 talks about general plan...

Queries Queries PRQL queries are composed of a sequence of transforms that form a pipeline that modifies data as it is passed from one to the next. The major items of a query ...

Integrations Integrations PRQL is building integrations with lots of external tools, including: Jupyter ClickHouse DuckDB Prefect VS Code Rill We also have a CLI, prql...

Internals Internals This chapter explains PRQL’s semantics: how expressions are interpreted and their meaning. It’s intended for advanced users and compiler contributors. Nam...

ClickHouse ClickHouse PRQL works natively in ClickHouse. Check out the ClickHouse docs for more details.

Rill Rill PRQL has had some work to integrate with Rill. See the Rill ssues for more details.