Query keywords

The following keywords are used in Data Shaping Query Language. They are case insensitive.

FROM to iterate on an input array.
AS to define an alias for an array.
INDEX to store an index for an iteration.
UNNEST to unnest a nested array.
WHERE to filter items.
SELECT to choose the elements to return in the query result.
JOIN or INNER JOIN to perform an inner join between two arrays.
LEFT OUTER JOIN to perform a left outer join between two arrays.
ON to define the condition to join two arrays.
ORDER BY to order items in an array.
DESC to order items in descending order.
ASC to order items in ascending order.
LIMIT to define a number of items to return in the query result.
OFFSET to define a number of items to ignore at the beginning of the query result.
UNION ALL to separate two query blocks.
WITH, LET and SET to define variables.
GROUP BY to group items generated in a previous clause.
GROUP AS to assign an alias to a group generated by a GROUP BY clause.
HAVING to filter groups.
TO and BY to generate an array of integers.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!