Examples Examples These examples are rewritten from other languages such as SQL. They try to express real-world problems in PRQL, covering most of the language features. We are...
Prefect Prefect Because Prefect is in native Python, it’s extremely easy to integrate with PRQL. With a Postgres Task, replace: PostgresExecute . run (..., query = sql ) ...
R (prqlr) Installation R (prqlr) R bindings for prql-compiler . prqlr also includes knitr (R Markdown and Quarto) integration, which allows us to easily create documents wi...
Loop Examples PRQL SQL Loop experimental Iteratively applies step function to initial relation until the step returns an empty table. Returns a relation that contains...
Development Setting up an initial dev environment Setting up a full dev environment Option 1: Use the project’s task Option 2: Install tools individually Building & testing the ...
Comments PRQL SQL Comments Character # denotes a comment until the end of the line. PRQL from employees # Comment 1 # Comment 2 aggregate { average salary } S...
Comments PRQL SQL Comments Character # denotes a comment until the end of the line. PRQL from employees # Comment 1 # Comment 2 aggregate { average salary } S...
Type system Purpose Principles Theory Type annotations Type definitions Container types Physical layout Examples Appendix Built-in primitives Type representations RQ func...