Array & Map Functions

SELECT ARRAY('a', 'b', 'c') -- ['a', 'b', 'c']
SELECT ARRAY(1, 2, 3) AS numbers

SELECT SIZE(tags) AS tag_count FROM company_data."123"

-- Array (1-based index)
SELECT ELEMENT_AT(ARRAY('a', 'b', 'c'), 2) -- 'b'

-- Map
SELECT ELEMENT_AT(properties, 'color') AS color FROM company_data."123"

SELECT ARRAY_FLATTEN(ARRAY(ARRAY(1, 2), ARRAY(3, 4))) -- [1, 2, 3, 4]

SELECT ARRAY_SORT(ARRAY(3, 1, 2)) -- [1, 2, 3]

SELECT t.user_id, tag
FROM company_data."123" t
LATERAL JOIN EXPLODE(t.tags) AS tag

SELECT t.user_id, element
FROM company_data."123" t, UNNEST(t.tags) AS element