Maps & structs Scalar

map_entries()

Returns the map entries as a list of keys/values

Arguments & returns

Scalar

Overload link	`map`	Returns
#01	`MAP(K, V)`	`STRUCT("key" K, "value" V)[]`

SELECT map_entries(map(['key'], ['val']));

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Used in larger rewrites 1

These examples use map_entries as one part of a larger SQL translation.

SELECT id, MAP_DELETE(attrs, del_key1, del_key2) AS attrs_after_delete FROM demo_maps

In DuckDB

SELECT 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