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 |