opteryx
opteryx copied to clipboard
✨ CROSS JOIN UNNEST on functions
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