On ClickHouse, unnest expands an array into rows
WITH
dt
AS
(
SELECT
unnest
(
array
[
1
,
2
])
AS
n
)
SELECT
*
FROM
dt
;