Maps & structs Scalar

map_keys()

Returns the keys of a map as a list

Arguments & returns

Scalar

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

SELECT map_keys(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_keys as one part of a larger SQL translation.

MAP_CONTAINS_KEY('k1', {'k1': 'v1', 'k2': 'v2', 'k3': 'v3'}::MAP(VARCHAR, VARCHAR))

In DuckDB

ARRAY_CONTAINS(MAP_KEYS(CAST({'k1': 'v1', 'k2': 'v2', 'k3': 'v3'} AS MAP(TEXT, TEXT))), 'k1')