# Concatenate two JSON arrays to produce an instance of JSON[] create or replace function jsonarray2list(j) as ( select list_transform(range(0, json_array_length(j)::BIGINT), i -> (j -> i)) );