Language features

The pages of this section describe how PRQL handles various aspects of the language.

Feature Purpose
Coalesce Handle potentially NULL values
Dates & times Handle dates and times
Distinct Equivalent of SQL DISTINCT
Null handling Handle NULL values
Ranges Syntax for all forms of ranges
Regex Handle regular expressions
Strings Rules for creating strings
S-strings Insert SQL directly into a query with an S-string
F-strings Combine several column’s data with F-strings
Case Create a new column based on the contents of other columns
Target & Version Specify a target SQL engine and PRQL version