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 |
Stdlib | PRQL’s “builtin” set of functions |
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 |
Switch | Create a new column based on the contents of other columns |
Target & Version | Specify a target SQL engine and PRQL version |