SQL
`STRUCT.*`
The `*` expression can also be used to retrieve all keys from a struct as separate columns.
This is particularly useful when a prior operation creates a struct of unknown shape, or if a query must handle any potential struct keys.
See the [`STRUCT` data type](#docs:sql:data_types:struct) and [`STRUCT` functions](#docs:sql:functions:struct) pages for more details on working with structs.  
For example:  
```sql
SELECT st.* FROM (SELECT {'x': 1, 'y': 2, 'z': 3} AS st);
```  
<div class="narrow_table"></div>  
| x | y | z |
|--:|--:|--:|
| 1 | 2 | 3 |