CopyInto with Named File Format in Snowflake hanging on parse

[kharigardner]

Related to:
#3434 & #3604

When a named FILE_FORMAT is provided in the COPY INTO ... query, it seems as if the Parser is hanging infinitely, without raising any error.

Example:

from sqlglot import parse_one

query = """
    COPY INTO MY_DATABASE.MY_SCHEMA.MY_TABLE
    FROM @MY_DATABASE.MY_SCHEMA.MY_STAGE/my_path
    FILE_FORMAT=(FORMAT_NAME = MY_DATABASE.MY_SCHEMA.MY_FILE_FORMAT)
"""
# will remain on this line
parsed = parse_one(query, dialect='snowflake')

If commenting out the file format, the parse result is as expected.

Docs: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table