Variables PRQL SQL PRQL SQL PRQL SQL Variables Variables assign a name — say x — to an expression, like in most programming languages. The name can then be used in any e...
Append PRQL SQL Remove PRQL SQL Intersection PRQL SQL Set operations Append Concatenates two tables together. Equivalent to UNION ALL in SQL. The number of rows is a...
Window Example PRQL SQL PRQL SQL Windowing by default PRQL SQL PRQL SQL Window functions as first class citizens PRQL SQL Window Applies a pipeline to segments of ...
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 ...
Append PRQL SQL Remove PRQL SQL Intersection PRQL SQL Set operations Append Concatenates two tables together. Equivalent to UNION ALL in SQL. The number of rows is a...
Standard library PRQL SQL PRQL SQL PRQL SQL Standard library The standard library currently contains commonly used functions that are used in SQL. It’s not yet as broad a...
Null handling PRQL SQL Null handling SQL has an unconventional way of handling NULL values, since it treats them as unknown values. As a result, in SQL: NULL is not a val...
Null handling PRQL SQL Null handling SQL has an unconventional way of handling NULL values, since it treats them as unknown values. As a result, in SQL: NULL is not a val...
Dates & times Dates PRQL SQL Times PRQL SQL Timestamps PRQL SQL Intervals PRQL SQL Examples Roadmap Datetimes Dates & times PRQL uses @ followed by a string to ...