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 |