Maps & structs
Scalar
map_entries()
Returns the map entries as a list of keys/values
Arguments & returns
map_entries(…)
Scalar
| Overload link | … Varargs | Returns |
|---|---|---|
| #01 | ANY |
LIST |
… accepts a variable number of arguments of the type shown.
Example
Haybarn WASM 1.5.5-rc3 · In your browser
Engine example · Run to view results.
In other engines
Used in larger rewrites 1
These examples use map_entries as one part of a larger SQL translation.
Snowflakemap_delete()
SELECT id, MAP_DELETE(attrs, del_key1, del_key2) AS attrs_after_delete FROM demo_maps
In DuckDBSELECT id, MAP_FROM_ENTRIES(LIST_FILTER(MAP_ENTRIES(attrs), x -> NOT x.key IN (del_key1, del_key2))) AS attrs_after_delete FROM demo_maps