Using Data Shaping Query Language
Data Shaping Query Language allows you to create queries to transform your data.
A query is a series of clauses that allow you to define the output data to return. It can contain a single block or multiple blocks separated by the UNION ALL keywords. These allow you to combine the results of several query blocks, with conditions if needed.
A query block can be a single SELECT clause or a combination of a SELECT clause and a FROM WHERE clause, which can contain UNNEST clauses, followed by a JOIN clause if needed.
The result of a query block can be:
- A single value.
- A record, or object, which contains a sequence of key-value pairs.
- An array, which can contains several values, records, or arrays.
When the result is an array, it can be modified by output modifiers such as the ORDER BY clause.