opteryx icon indicating copy to clipboard operation
opteryx copied to clipboard

✨ CROSS JOIN UNNEST on functions

Open joocer opened this issue 8 months ago • 0 comments
trafficstars

As a contrived example, we should be able to UNNEST on the result of a function:

SELECT mission FROM $astronauts CROSS JOIN UNNEST(CAST(missions AS ARRAY<BLOB>)) AS mission

joocer avatar Mar 08 '25 19:03 joocer