CREATE TABLE USING TEMPLATE outputted incorrectly for Snowflake

[kharigardner]

Hello!

Code snippet:

from sqlglot import parse_one

query = """
  CREATE TABLE IF NOT EXISTS MY_DATABASE.MY_SCHEMA.MY_TABLE
  USING TEMPLATE (
      SELECT ARRAY_AGG(OBJECT_CONSTRUCT(*))
      FROM TABLE(
          INFER_SCHEMA(
              LOCATION => '@MY_DATABASE.MY_SCHEMA.MY_STAGE/my_path' -- noqa: LT05
              , FILES => ('MY_FILE.csv') -- noqa: LT05
              , FILE_FORMAT => 'MY_DATABASE.MY_SCHEMA.MY_FILE_FORMAT' -- noqa: LT05
          )
      )
  );
"""

# parses as an expression fine
parsed = parse_one(query, dialect='snowflake')

# outputs incorrect sql
parsed.sql(dialect='snowflake')

###### Output, which leads to a syntax error in Snowflake
"""
CREATE TABLE IF NOT EXISTS MY_DATABASE.MY_SCHEMA.MY_TABLE 
FORMAT=TEMPLATE(
    SELECT ARRAY_AGG(OBJECT_CONSTRUCT(*)) 
    FROM TABLE(INFER_SCHEMA(
        LOCATION => '@MY_DATABASE.MY_SCHEMA.MY_STAGE/my_path' /* noqa: LT05 */, 
        FILES => ('MY_FILE.csv') /* noqa: LT05 */, 
        FILE_FORMAT => 'MY_DATABASE.MY_SCHEMA.MY_FILE_FORMAT' /* noqa: LT05 */
    ))
)
"""

Snowflake Docs -> https://docs.snowflake.com/en/sql-reference/sql/create-table#create-table-using-template