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...

R (prqlr) Installation Usage R (prqlr) R bindings for prql-compiler . prqlr also includes knitr (R Markdown and Quarto) integration, which allows us to easily create docum...

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...

Loop Examples PRQL SQL Loop Experimental loop { step_function } { initial_relation } Iteratively applies step function to initial relation until the step return...

Standard library PRQL SQL Standard library The standard library currently contains commonly used functions that are used in SQL. It’s not yet as broad as we’d like, and we’re...

Bindings Supported Unsupported Nascent Bindings PRQL has bindings for many languages. These include: We have three tiers of bindings: Supported Unsupported Nascent Supp...

Text functions Example PRQL SQL Text functions These are all the functions defined in the text module: function parameters description contains sub col Returns true if c...

Mathematical functions Example PRQL SQL Mathematical functions These are all the functions defined in the math module: function parameters description abs col Absolute va...

Reading files PRQL SQL Reading files We have a couple of functions named read_* , which ask the DB to read files, designed for DuckDB: PRQL from ( read_parquet 'artists...

Language features Language features The pages of this section describe how PRQL handles various aspects of the language. Feature Purpose Coalesce Handle potentially NULL value...