Maps & structs Scalar

map_from_entries()

Returns a map created from the entries of the array

Arguments & returns

Scalar

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

SELECT map_from_entries([{k: 5, v: 'val1'}, {k: 3, v: 'val2'}]);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

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