The following examples are features that are not present in SQL. They are not impossible to do in SQL, but just painful.
Delightql offers these features to make the developer experience a little bit more pleasant.
This list is not comprehensive. See the language reference.
PROJECT OUT
Remove columns from a relation.
MAP COVER
Run a function over a set of columns but leave all other columns in place
RENAME COVER
Rename some columns but leave all other columns in place.
INDEX SELECTING
Choose columns by their ordinal index. Useful for ETL and nasty tables.
RANGE SELECTING
Choose columns by ordinal range.
TREE-GROUPING
Embrace zeroth-normal form data by rolling up multiple levels of aggregation into a tree.
COMMON FUNCTION EXPRESSIONS
Define functions at the top of your query and use them. Example shows functional piping too.
REGEX SELECTING
Select your columns based on a pattern of their name.
ORDINAL REORDER
Rearrange the columns' ordinality.
RAGGED UNION
UNION almost matching schemas together with null padding and matching by name.