fakesnow
fakesnow copied to clipboard
Issue: FROM table() raises unexpected error
SELECT
"zeta"
FROM
table(flatten(ARRAY_CONSTRUCT(1, 2, 3, 4))) as unnest_wrapper ( unnest1, unnest2, unnest3, unnest4, "zeta")
raises a "Parser Error: syntax error at or near "TABLE", but appears to run properly in snowflake.
Wanted to first confirm it's actually an issue, then happy to take look at a fix.
Thanks for raising this, and yes if it runs in snowflake and not fakesnow its an issue.