Maps & structs Scalar

map_from_entries()

Returns a map created from the entries of the array

Arguments & returns

Scalar

Overload link	… Varargs	Returns
#01	`ANY`	`MAP`

… accepts a variable number of arguments of the type shown.

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