Parsing issue for Snowflake COPY INTO queries with subqueries

[whummer]

Hi folks,

looks like we're facing an issue when parsing Snowflake COPY INTO queries with SELECT subqueries:

query = "COPY INTO test (c1) FROM (SELECT $1:c1::string FROM @mystage)"
parse_one(query, read="snowflake")

... which yields the following error:

sqlglot.errors.ParseError: Expected table name but got <Token token_type: TokenType.L_PAREN, text: (, line: 1, col: 32, start: 31, end: 31, comments: []>. Line 1, Col: 32.
COPY INTO t_d56103e1 (c1) FROM (SELECT $1:c1::string FROM @"mystage")

(The query has been validated to run successfully against Snowflake.)

Please let me know if you need any additional information, and whether I can help out with a PR/fix for this. 🙌 Thanks!