bigquery_comma_unnest.sql

WITH Sequences AS (SELECT 1 AS id, [0, 1, 1, 2, 3, 5] AS some_numbers, [10, 51, 17, 28, 31, 55] AS some_more_numbers
   UNION ALL SELECT 2 AS id, [2, 4, 8, 16, 32] AS some_numbers, [231, 43, 8, 1, 77] AS some_more_numbers
   UNION ALL SELECT 3 AS id, [5, 10] AS some_numbers, [5555,  13515] AS some_more_numbers)
SELECT id, flattened_numbers, more_flattened_numbers
FROM Sequences,
UNNEST(some_numbers) AS flattened_numbers,
UNNEST(some_more_numbers) AS more_flattened_numbers;