4 lines
199 B
Text
4 lines
199 B
Text
create or replace function keys_values_object( keys, values ) as (
|
|
list_transform( keys, (k,i) -> json_object(k, json_extract(values, i-1)))
|
|
.list_reduce( (acc,x) -> json_merge_patch(acc, x))
|
|
);
|