unnest array col to single row - prayagupa/rdb GitHub Wiki

-- unnest array col to single row

with my_table AS (
  SELECT  event_id, upcs
  FROM ads
  WHERE event_time > '2023-05-20'
) SELECT event_id, upcs 
  FROM my_table, UNNEST(upcs) upcs;