Grammar railroad diagram

[mingodad]

Using some online tools like https://www.bottlecaps.de/rr/ui and https://www.bottlecaps.de/convert/ we can have a nice navigable railroad diagram.

Copy and paste the EBNF shown bellow on https://www.bottlecaps.de/rr/ui on the tab Edit Grammar the click on the tab View Diagram to see/download a navigable railroad diagram. Note updated the EBNF to this grammar commit https://github.com/google/zetasql/blob/194cd32b5d766d60e3ca442651d792c7fe54ea74/zetasql/parser/bison_parser.y

//
// EBNF to be viewd at
//    (IPV6) https://www.bottlecaps.de/rr/ui
//    (IPV4) https://rr.red-dove.com/ui
//
// Copy and paste this at one of the urls shown above in the 'Edit Grammar' tab
// then click the 'View Diagram' tab.
//

start_mode::=
      MODE_STATEMENT sql_statement
    | MODE_SCRIPT script
    | MODE_NEXT_STATEMENT next_statement
    | MODE_NEXT_SCRIPT_STATEMENT next_script_statement
    | MODE_NEXT_STATEMENT_KIND next_statement_kind
    | MODE_EXPRESSION expression
    | MODE_TYPE type

opt_semicolon::=
      ';'
    | /*%empty*/

sql_statement::=
      unterminated_sql_statement opt_semicolon

next_script_statement::=
      unterminated_statement ';'
    | unterminated_statement

next_statement::=
      unterminated_sql_statement ';'
    | unterminated_sql_statement

pre_statement::=
      /*%empty*/

unterminated_statement::=
      pre_statement unterminated_sql_statement
    | pre_statement unterminated_script_statement

statement_level_hint::=
      hint

unterminated_sql_statement::=
      sql_statement_body
    | statement_level_hint sql_statement_body
    | KW_DEFINE KW_MACRO
    | statement_level_hint KW_DEFINE KW_MACRO
    | statement_level_hint KW_DEFINE_FOR_MACROS KW_MACRO

unterminated_unlabeled_script_statement::=
      begin_end_block
    | while_statement
    | loop_statement
    | repeat_statement
    | for_in_statement

unterminated_script_statement::=
      if_statement
    | case_statement
    | variable_declaration
    | break_statement
    | continue_statement
    | return_statement
    | raise_statement
    | unterminated_unlabeled_script_statement
    | label ':' unterminated_unlabeled_script_statement opt_identifier

sql_statement_body::=
      query_statement
    | alter_statement
    | analyze_statement
    | assert_statement
    | aux_load_data_statement
    | clone_data_statement
    | dml_statement
    | merge_statement
    | truncate_statement
    | begin_statement
    | set_statement
    | commit_statement
    | start_batch_statement
    | run_batch_statement
    | abort_batch_statement
    | create_constant_statement
    | create_connection_statement
    | create_database_statement
    | create_function_statement
    | create_procedure_statement
    | create_index_statement
    | create_privilege_restriction_statement
    | create_row_access_policy_statement
    | create_external_table_statement
    | create_external_table_function_statement
    | create_model_statement
    | create_schema_statement
    | create_external_schema_statement
    | create_snapshot_statement
    | create_table_function_statement
    | create_table_statement
    | create_view_statement
    | create_entity_statement
    | define_macro_statement
    | define_table_statement
    | describe_statement
    | execute_immediate
    | explain_statement
    | export_data_statement
    | export_model_statement
    | export_metadata_statement
    | grant_statement
    | rename_statement
    | revoke_statement
    | rollback_statement
    | show_statement
    | drop_all_row_access_policies_statement
    | drop_statement
    | call_statement
    | import_statement
    | module_statement
    | undrop_statement

define_macro_statement::=
      KW_DEFINE_FOR_MACROS KW_MACRO MACRO_BODY_TOKEN macro_body

macro_body::=
      /*%empty*/
    | macro_token_list

macro_token_list::=
      MACRO_BODY_TOKEN
    | macro_token_list MACRO_BODY_TOKEN

query_statement::=
      query

alter_action::=
      KW_SET KW_OPTIONS options_list
    | KW_SET KW_AS generic_entity_body
    | KW_ADD table_constraint_spec
    | KW_ADD primary_key_spec
    | KW_ADD KW_CONSTRAINT opt_if_not_exists identifier primary_key_or_table_constraint_spec
    | KW_DROP KW_CONSTRAINT opt_if_exists identifier
    | KW_DROP KW_PRIMARY KW_KEY opt_if_exists
    | KW_ALTER KW_CONSTRAINT opt_if_exists identifier constraint_enforcement
    | KW_ALTER KW_CONSTRAINT opt_if_exists identifier KW_SET KW_OPTIONS options_list
    | KW_ADD KW_COLUMN opt_if_not_exists table_column_definition opt_column_position opt_fill_using_expression
    | KW_DROP KW_COLUMN opt_if_exists identifier
    | KW_RENAME KW_COLUMN opt_if_exists identifier KW_TO identifier
    | KW_ALTER KW_COLUMN opt_if_exists identifier KW_SET KW_DATA KW_TYPE field_schema
    | KW_ALTER KW_COLUMN opt_if_exists identifier KW_SET KW_OPTIONS options_list
    | KW_ALTER KW_COLUMN opt_if_exists identifier KW_SET KW_DEFAULT expression
    | KW_ALTER KW_COLUMN opt_if_exists identifier KW_DROP KW_DEFAULT
    | KW_ALTER KW_COLUMN opt_if_exists identifier KW_DROP KW_NOT KW_NULL
    | KW_ALTER KW_COLUMN opt_if_exists identifier KW_DROP KW_GENERATED
    | KW_RENAME KW_TO path_expression
    | KW_SET KW_DEFAULT collate_clause
    | KW_ADD KW_ROW KW_DELETION KW_POLICY opt_if_not_exists '(' expression ')'
    | KW_REPLACE KW_ROW KW_DELETION KW_POLICY opt_if_exists '(' expression ')'
    | KW_DROP KW_ROW KW_DELETION KW_POLICY opt_if_exists
    | KW_ALTER generic_sub_entity_type opt_if_exists identifier alter_action
    | KW_ADD generic_sub_entity_type opt_if_not_exists identifier opt_options_list
    | KW_DROP generic_sub_entity_type opt_if_exists identifier
    | spanner_alter_column_action
    | spanner_set_on_delete_action

alter_action_list::=
      alter_action
    | alter_action_list ',' alter_action

privilege_restriction_alter_action::=
      restrict_to_clause
    | KW_ADD opt_if_not_exists possibly_empty_grantee_list
    | KW_REMOVE opt_if_exists possibly_empty_grantee_list

privilege_restriction_alter_action_list::=
      privilege_restriction_alter_action
    | privilege_restriction_alter_action_list ',' privilege_restriction_alter_action

row_access_policy_alter_action::=
      grant_to_clause
    | KW_FILTER KW_USING '(' expression ')'
    | KW_REVOKE KW_FROM '(' grantee_list ')'
    | KW_REVOKE KW_FROM KW_ALL
    | KW_RENAME KW_TO identifier

row_access_policy_alter_action_list::=
      row_access_policy_alter_action
    | row_access_policy_alter_action_list ',' row_access_policy_alter_action

schema_object_kind::=
      KW_AGGREGATE KW_FUNCTION
    | KW_APPROX KW_VIEW
    | KW_CONNECTION
    | KW_CONSTANT
    | KW_DATABASE
    | KW_EXTERNAL table_or_table_function
    | KW_EXTERNAL KW_SCHEMA
    | KW_FUNCTION
    | KW_INDEX
    | KW_MATERIALIZED KW_VIEW
    | KW_MODEL
    | KW_PROCEDURE
    | KW_SCHEMA
    | KW_VIEW

alter_statement::=
      KW_ALTER table_or_table_function opt_if_exists maybe_dashed_path_expression alter_action_list
    | KW_ALTER schema_object_kind opt_if_exists path_expression alter_action_list
    | KW_ALTER generic_entity_type opt_if_exists path_expression alter_action_list
    | KW_ALTER generic_entity_type opt_if_exists alter_action_list
    | KW_ALTER KW_PRIVILEGE KW_RESTRICTION opt_if_exists KW_ON privilege_list KW_ON identifier path_expression privilege_restriction_alter_action_list
    | KW_ALTER KW_ROW KW_ACCESS KW_POLICY opt_if_exists identifier KW_ON path_expression row_access_policy_alter_action_list
    | KW_ALTER KW_ALL KW_ROW KW_ACCESS KW_POLICIES KW_ON path_expression row_access_policy_alter_action

opt_input_output_clause::=
      KW_INPUT table_element_list KW_OUTPUT table_element_list
    | /*%empty*/

opt_transform_clause::=
      KW_TRANSFORM '(' select_list ')'
    | /*%empty*/

assert_statement::=
      KW_ASSERT expression opt_description

opt_description::=
      KW_AS string_literal
    | /*%empty*/

analyze_statement::=
      KW_ANALYZE opt_options_list opt_table_and_column_info_list

opt_table_and_column_info_list::=
      table_and_column_info_list
    | /*%empty*/

table_and_column_info_list::=
      table_and_column_info
    | table_and_column_info_list ',' table_and_column_info

table_and_column_info::=
      maybe_dashed_path_expression opt_column_list

transaction_mode::=
      KW_READ KW_ONLY
    | KW_READ KW_WRITE
    | KW_ISOLATION KW_LEVEL identifier
    | KW_ISOLATION KW_LEVEL identifier identifier

transaction_mode_list::=
      transaction_mode
    | transaction_mode_list ',' transaction_mode

opt_transaction_mode_list::=
      transaction_mode_list
    | /*%empty*/

begin_statement::=
      begin_transaction_keywords opt_transaction_mode_list

begin_transaction_keywords::=
      KW_START transaction_keyword
    | KW_BEGIN opt_transaction_keyword

transaction_keyword::=
      KW_TRANSACTION

opt_transaction_keyword::=
      transaction_keyword
    | /*%empty*/

set_statement::=
      KW_SET KW_TRANSACTION transaction_mode_list
    | KW_SET identifier '=' expression
    | KW_SET named_parameter_expression '=' expression
    | KW_SET system_variable_expression '=' expression
    | KW_SET '(' identifier_list ')' '=' expression
    | KW_SET '(' ')'
    | KW_SET identifier ',' identifier_list '='

commit_statement::=
      KW_COMMIT opt_transaction_keyword

rollback_statement::=
      KW_ROLLBACK opt_transaction_keyword

start_batch_statement::=
      KW_START KW_BATCH opt_identifier

run_batch_statement::=
      KW_RUN KW_BATCH

abort_batch_statement::=
      KW_ABORT KW_BATCH

create_constant_statement::=
      KW_CREATE opt_or_replace opt_create_scope KW_CONSTANT opt_if_not_exists path_expression '=' expression

create_database_statement::=
      KW_CREATE KW_DATABASE path_expression opt_options_list

unordered_options_body::=
      options opt_as_sql_function_body_or_string
    | as_sql_function_body_or_string opt_options_list
    | /*%empty*/

create_function_statement::=
      KW_CREATE opt_or_replace opt_create_scope opt_aggregate KW_FUNCTION opt_if_not_exists function_declaration opt_function_returns opt_sql_security_clause opt_determinism_level opt_language_or_remote_with_connection unordered_options_body

opt_aggregate::=
      KW_AGGREGATE
    | /*%empty*/

opt_not_aggregate::=
      KW_NOT KW_AGGREGATE
    | /*%empty*/

function_declaration::=
      path_expression function_parameters

function_parameter::=
      identifier type_or_tvf_schema opt_as_alias_with_required_as opt_default_expression opt_not_aggregate
    | type_or_tvf_schema opt_as_alias_with_required_as opt_not_aggregate

function_parameters_prefix::=
      '(' function_parameter
    | function_parameters_prefix ',' function_parameter

function_parameters::=
      function_parameters_prefix ')'
    | '(' ')'

begin_end_block_or_language_as_code::=
      begin_end_block
    | KW_LANGUAGE identifier opt_as_code

opt_external_security_clause::=
      KW_EXTERNAL KW_SECURITY external_security_clause_kind
    | /*%empty*/

external_security_clause_kind::=
      KW_INVOKER
    | KW_DEFINER

create_procedure_statement::=
      KW_CREATE opt_or_replace opt_create_scope KW_PROCEDURE opt_if_not_exists path_expression procedure_parameters opt_external_security_clause opt_with_connection_clause opt_options_list begin_end_block_or_language_as_code

procedure_parameters_prefix::=
      '(' procedure_parameter
    | procedure_parameters_prefix ',' procedure_parameter

procedure_parameters::=
      procedure_parameters_prefix ')'
    | '(' ')'

procedure_parameter_termination::=
      ')'
    | ','

procedure_parameter::=
      opt_procedure_parameter_mode identifier type_or_tvf_schema
    | opt_procedure_parameter_mode identifier procedure_parameter_termination

opt_procedure_parameter_mode::=
      KW_IN
    | KW_OUT
    | KW_INOUT
    | /*%empty*/

opt_returns::=
      KW_RETURNS type_or_tvf_schema
    | /*%empty*/

opt_function_returns::=
      opt_returns

opt_determinism_level::=
      KW_DETERMINISTIC
    | KW_NOT KW_DETERMINISTIC
    | KW_IMMUTABLE
    | KW_STABLE
    | KW_VOLATILE
    | /*%empty*/

language::=
      KW_LANGUAGE identifier

opt_language::=
      language
    | /*%empty*/

remote_with_connection_clause::=
      KW_REMOTE opt_with_connection_clause
    | with_connection_clause

opt_remote_with_connection_clause::=
      remote_with_connection_clause
    | /*%empty*/

opt_language_or_remote_with_connection::=
      KW_LANGUAGE identifier opt_remote_with_connection_clause
    | remote_with_connection_clause opt_language
    | /*%empty*/

opt_sql_security_clause::=
      KW_SQL KW_SECURITY sql_security_clause_kind
    | /*%empty*/

sql_security_clause_kind::=
      KW_INVOKER
    | KW_DEFINER

as_sql_function_body_or_string::=
      KW_AS sql_function_body
    | KW_AS string_literal

opt_as_sql_function_body_or_string::=
      as_sql_function_body_or_string
    | /*%empty*/

opt_as_code::=
      KW_AS string_literal
    | /*%empty*/

path_expression_or_string::=
      path_expression
    | string_literal

path_expression_or_default::=
      path_expression
    | KW_DEFAULT

sql_function_body::=
      '(' expression ')'
    | '(' KW_SELECT

restrict_to_clause::=
      KW_RESTRICT KW_TO possibly_empty_grantee_list

opt_restrict_to_clause::=
      restrict_to_clause
    | /*%empty*/

grant_to_clause::=
      KW_GRANT KW_TO '(' grantee_list ')'

create_row_access_policy_grant_to_clause::=
      grant_to_clause
    | KW_TO grantee_list

opt_create_row_access_policy_grant_to_clause::=
      create_row_access_policy_grant_to_clause
    | /*%empty*/

opt_filter::=
      KW_FILTER
    | /*%empty*/

filter_using_clause::=
      opt_filter KW_USING '(' expression ')'

create_privilege_restriction_statement::=
      KW_CREATE opt_or_replace KW_PRIVILEGE KW_RESTRICTION opt_if_not_exists KW_ON privilege_list KW_ON identifier path_expression opt_restrict_to_clause

create_row_access_policy_statement::=
      KW_CREATE opt_or_replace KW_ROW opt_access KW_POLICY opt_if_not_exists opt_identifier KW_ON path_expression opt_create_row_access_policy_grant_to_clause filter_using_clause

with_partition_columns_clause::=
      KW_WITH KW_PARTITION KW_COLUMNS opt_table_element_list

with_connection_clause::=
      KW_WITH connection_clause

opt_external_table_with_clauses::=
      with_partition_columns_clause with_connection_clause
    | with_partition_columns_clause
    | with_connection_clause
    | /*%empty*/

create_external_table_statement::=
      KW_CREATE opt_or_replace opt_create_scope KW_EXTERNAL KW_TABLE opt_if_not_exists maybe_dashed_path_expression opt_table_element_list opt_like_path_expression opt_default_collate_clause opt_external_table_with_clauses opt_options_list

create_external_table_function_statement::=
      KW_CREATE opt_or_replace opt_create_scope KW_EXTERNAL KW_TABLE KW_FUNCTION

opt_create_index_statement_suffix::=
      partition_by_clause_prefix_no_hint opt_options_list
    | opt_options_list spanner_index_interleave_clause
    | options
    | /*%empty*/

create_index_statement::=
      KW_CREATE opt_or_replace opt_unique opt_spanner_null_filtered opt_index_type KW_INDEX opt_if_not_exists path_expression on_path_expression opt_as_alias opt_index_unnest_expression_list index_order_by_and_options opt_index_storing_list opt_create_index_statement_suffix

create_schema_statement::=
      KW_CREATE opt_or_replace KW_SCHEMA opt_if_not_exists path_expression opt_default_collate_clause opt_options_list

create_external_schema_statement::=
      KW_CREATE opt_or_replace opt_create_scope KW_EXTERNAL KW_SCHEMA opt_if_not_exists path_expression opt_with_connection_clause options

create_connection_statement::=
      KW_CREATE opt_or_replace KW_CONNECTION opt_if_not_exists path_expression opt_options_list

undrop_statement::=
      KW_UNDROP schema_object_kind opt_if_not_exists path_expression opt_at_system_time opt_options_list

create_snapshot_statement::=
      KW_CREATE opt_or_replace KW_SNAPSHOT KW_TABLE opt_if_not_exists maybe_dashed_path_expression KW_CLONE clone_data_source opt_options_list
    | KW_CREATE opt_or_replace KW_SNAPSHOT schema_object_kind opt_if_not_exists maybe_dashed_path_expression KW_CLONE clone_data_source opt_options_list

unordered_language_options::=
      language opt_options_list
    | options opt_language
    | /*%empty*/

create_table_function_statement::=
      KW_CREATE opt_or_replace opt_create_scope KW_TABLE KW_FUNCTION opt_if_not_exists path_expression opt_function_parameters opt_returns opt_sql_security_clause unordered_language_options opt_as_query_or_string

create_table_statement::=
      KW_CREATE opt_or_replace opt_create_scope KW_TABLE opt_if_not_exists maybe_dashed_path_expression opt_table_element_list opt_spanner_table_options opt_like_path_expression opt_clone_table opt_copy_table opt_default_collate_clause opt_partition_by_clause_no_hint opt_cluster_by_clause_no_hint opt_ttl_clause opt_with_connection_clause opt_options_list opt_as_query

append_or_overwrite::=
      KW_INTO
    | KW_OVERWRITE

aux_load_data_from_files_options_list::=
      KW_FROM KW_FILES options_list

opt_overwrite::=
      KW_OVERWRITE
    | /*%empty*/

load_data_partitions_clause::=
      opt_overwrite KW_PARTITIONS '(' expression ')'

opt_load_data_partitions_clause::=
      load_data_partitions_clause
    | /*%empty*/

maybe_dashed_path_expression_with_scope::=
      KW_TEMP KW_TABLE maybe_dashed_path_expression
    | KW_TEMPORARY KW_TABLE maybe_dashed_path_expression
    | maybe_dashed_path_expression

aux_load_data_statement::=
      KW_LOAD KW_DATA append_or_overwrite maybe_dashed_path_expression_with_scope opt_table_element_list opt_load_data_partitions_clause opt_collate_clause opt_partition_by_clause_no_hint opt_cluster_by_clause_no_hint opt_options_list aux_load_data_from_files_options_list opt_external_table_with_clauses

generic_entity_type_unchecked::=
      IDENTIFIER
    | KW_PROJECT

generic_entity_type::=
      generic_entity_type_unchecked

sub_entity_type_identifier::=
      IDENTIFIER
    | KW_REPLICA

generic_sub_entity_type::=
      sub_entity_type_identifier

generic_entity_body::=
      json_literal
    | string_literal

opt_generic_entity_body::=
      KW_AS generic_entity_body
    | /*%empty*/

create_entity_statement::=
      KW_CREATE opt_or_replace generic_entity_type opt_if_not_exists path_expression opt_options_list opt_generic_entity_body

create_model_statement::=
      KW_CREATE opt_or_replace opt_create_scope KW_MODEL opt_if_not_exists path_expression opt_input_output_clause opt_transform_clause opt_remote_with_connection_clause opt_options_list opt_as_query_or_aliased_query_list

opt_table_element_list::=
      table_element_list
    | /*%empty*/

table_element_list::=
      table_element_list_prefix ')'
    | '(' ')'

table_element_list_prefix::=
      '(' table_element
    | table_element_list_prefix ',' table_element
    | table_element_list_prefix ','

table_element::=
      table_column_definition
    | table_constraint_definition

table_column_definition::=
      identifier table_column_schema opt_column_attributes opt_options_list

table_column_schema::=
      column_schema_inner opt_collate_clause opt_column_info
    | generated_column_info

simple_column_schema_inner::=
      path_expression
    | KW_INTERVAL

array_column_schema_inner::=
      KW_ARRAY template_type_open field_schema template_type_close

range_column_schema_inner::=
      KW_RANGE template_type_open field_schema template_type_close

struct_column_field::=
      column_schema_inner opt_collate_clause opt_field_attributes
    | identifier field_schema

struct_column_schema_prefix::=
      KW_STRUCT template_type_open struct_column_field
    | struct_column_schema_prefix ',' struct_column_field

struct_column_schema_inner::=
      KW_STRUCT template_type_open template_type_close
    | struct_column_schema_prefix template_type_close

raw_column_schema_inner::=
      simple_column_schema_inner
    | array_column_schema_inner
    | struct_column_schema_inner
    | range_column_schema_inner

column_schema_inner::=
      raw_column_schema_inner opt_type_parameters

generated_mode::=
      KW_GENERATED KW_AS
    | KW_GENERATED KW_ALWAYS KW_AS
    | KW_GENERATED KW_BY KW_DEFAULT KW_AS
    | KW_AS

stored_mode::=
      KW_STORED KW_VOLATILE
    | KW_STORED
    | /*%empty*/

signed_numerical_literal::=
      integer_literal
    | numeric_literal
    | bignumeric_literal
    | floating_point_literal
    | '-' integer_literal
    | '-' floating_point_literal

opt_start_with::=
      KW_START KW_WITH signed_numerical_literal
    | /*%empty*/

opt_increment_by::=
      KW_INCREMENT KW_BY signed_numerical_literal
    | /*%empty*/

opt_maxvalue::=
      KW_MAXVALUE signed_numerical_literal
    | /*%empty*/

opt_minvalue::=
      KW_MINVALUE signed_numerical_literal
    | /*%empty*/

opt_cycle::=
      KW_CYCLE
    | KW_NO KW_CYCLE
    | /*%empty*/

identity_column_info::=
      KW_IDENTITY '(' opt_start_with opt_increment_by opt_maxvalue opt_minvalue opt_cycle ')'

generated_column_info::=
      generated_mode '(' expression ')' stored_mode
    | generated_mode identity_column_info

invalid_generated_column::=
      generated_column_info
    | /*%empty*/

default_column_info::=
      KW_DEFAULT expression

invalid_default_column::=
      default_column_info
    | /*%empty*/

opt_column_info::=
      generated_column_info invalid_default_column
    | default_column_info invalid_generated_column
    | /*%empty*/

field_schema::=
      column_schema_inner opt_collate_clause opt_field_attributes opt_options_list

primary_key_column_attribute::=
      KW_PRIMARY KW_KEY

foreign_key_column_attribute::=
      opt_constraint_identity foreign_key_reference

hidden_column_attribute::=
      KW_HIDDEN

not_null_column_attribute::=
      KW_NOT KW_NULL

column_attribute::=
      primary_key_column_attribute
    | foreign_key_column_attribute
    | hidden_column_attribute
    | not_null_column_attribute

column_attributes::=
      column_attribute
    | column_attributes column_attribute
    | column_attributes constraint_enforcement

opt_column_attributes::=
      column_attributes
    | /*%empty*/

opt_field_attributes::=
      not_null_column_attribute
    | /*%empty*/

column_position::=
      KW_PRECEDING identifier
    | KW_FOLLOWING identifier

opt_column_position::=
      column_position
    | /*%empty*/

fill_using_expression::=
      KW_FILL KW_USING expression

opt_fill_using_expression::=
      fill_using_expression
    | /*%empty*/

table_constraint_spec::=
      KW_CHECK '(' expression ')' opt_constraint_enforcement opt_options_list
    | KW_FOREIGN KW_KEY column_list foreign_key_reference opt_constraint_enforcement opt_options_list

primary_key_element::=
      identifier opt_asc_or_desc opt_null_order

primary_key_element_list_prefix::=
      '(' primary_key_element
    | primary_key_element_list_prefix ',' primary_key_element

primary_key_element_list::=
      primary_key_element_list_prefix ')'
    | '(' ')'

primary_key_spec::=
      KW_PRIMARY KW_KEY primary_key_element_list opt_constraint_enforcement opt_options_list

primary_key_or_table_constraint_spec::=
      primary_key_spec
    | table_constraint_spec

table_constraint_definition::=
      primary_key_spec
    | table_constraint_spec
    | identifier identifier table_constraint_spec

foreign_key_reference::=
      KW_REFERENCES path_expression column_list opt_foreign_key_match opt_foreign_key_actions

opt_foreign_key_match::=
      KW_MATCH foreign_key_match_mode
    | /*%empty*/

foreign_key_match_mode::=
      KW_SIMPLE
    | KW_FULL
    | KW_NOT_SPECIAL KW_DISTINCT

opt_foreign_key_actions::=
      foreign_key_on_update opt_foreign_key_on_delete
    | foreign_key_on_delete opt_foreign_key_on_update
    | /*%empty*/

opt_foreign_key_on_update::=
      foreign_key_on_update
    | /*%empty*/

opt_foreign_key_on_delete::=
      foreign_key_on_delete
    | /*%empty*/

foreign_key_on_update::=
      KW_ON KW_UPDATE foreign_key_action

foreign_key_on_delete::=
      KW_ON KW_DELETE foreign_key_action

foreign_key_action::=
      KW_NO KW_ACTION
    | KW_RESTRICT
    | KW_CASCADE
    | KW_SET KW_NULL

opt_constraint_identity::=
      KW_CONSTRAINT identifier
    | /*%empty*/

opt_constraint_enforcement::=
      constraint_enforcement
    | /*%empty*/

constraint_enforcement::=
      KW_ENFORCED
    | KW_NOT KW_ENFORCED

table_or_table_function::=
      KW_TABLE KW_FUNCTION
    | KW_TABLE

tvf_schema_column::=
      identifier type
    | type

tvf_schema_prefix::=
      KW_TABLE template_type_open tvf_schema_column
    | tvf_schema_prefix ',' tvf_schema_column

tvf_schema::=
      tvf_schema_prefix template_type_close

opt_recursive::=
      KW_RECURSIVE
    | /*%empty*/

create_view_statement::=
      KW_CREATE opt_or_replace opt_create_scope opt_recursive KW_VIEW opt_if_not_exists maybe_dashed_path_expression opt_column_with_options_list opt_sql_security_clause opt_options_list as_query
    | KW_CREATE opt_or_replace KW_MATERIALIZED opt_recursive KW_VIEW opt_if_not_exists maybe_dashed_path_expression opt_column_with_options_list opt_sql_security_clause opt_partition_by_clause_no_hint opt_cluster_by_clause_no_hint opt_options_list KW_AS query_or_replica_source
    | KW_CREATE opt_or_replace KW_APPROX opt_recursive KW_VIEW opt_if_not_exists maybe_dashed_path_expression opt_column_with_options_list opt_sql_security_clause opt_options_list as_query

query_or_replica_source::=
      query
    | KW_REPLICA KW_OF maybe_dashed_path_expression

as_query::=
      KW_AS query

opt_as_query::=
      as_query
    | /*%empty*/

opt_as_query_or_string::=
      as_query
    | KW_AS string_literal
    | /*%empty*/

opt_as_query_or_aliased_query_list::=
      as_query
    | KW_AS '(' aliased_query_list ')'
    | /*%empty*/

opt_if_not_exists::=
      KW_IF KW_NOT KW_EXISTS
    | /*%empty*/

describe_statement::=
      describe_keyword describe_info

describe_info::=
      identifier maybe_slashed_or_dashed_path_expression opt_from_path_expression
    | maybe_slashed_or_dashed_path_expression opt_from_path_expression

opt_from_path_expression::=
      KW_FROM maybe_slashed_or_dashed_path_expression
    | /*%empty*/

explain_statement::=
      KW_EXPLAIN unterminated_sql_statement

export_data_statement::=
      KW_EXPORT KW_DATA opt_with_connection_clause opt_options_list KW_AS query

export_model_statement::=
      KW_EXPORT KW_MODEL path_expression opt_with_connection_clause opt_options_list

export_metadata_statement::=
      KW_EXPORT table_or_table_function KW_METADATA KW_FROM maybe_dashed_path_expression opt_with_connection_clause opt_options_list

grant_statement::=
      KW_GRANT privileges KW_ON identifier path_expression KW_TO grantee_list
    | KW_GRANT privileges KW_ON identifier identifier path_expression KW_TO grantee_list
    | KW_GRANT privileges KW_ON path_expression KW_TO grantee_list

revoke_statement::=
      KW_REVOKE privileges KW_ON identifier path_expression KW_FROM grantee_list
    | KW_REVOKE privileges KW_ON identifier identifier path_expression KW_FROM grantee_list
    | KW_REVOKE privileges KW_ON path_expression KW_FROM grantee_list

privileges::=
      KW_ALL opt_privileges_keyword
    | privilege_list

opt_privileges_keyword::=
      KW_PRIVILEGES
    | /*%empty*/

privilege_list::=
      privilege
    | privilege_list ',' privilege

privilege::=
      privilege_name opt_path_expression_list_with_parens

privilege_name::=
      identifier
    | KW_SELECT

rename_statement::=
      KW_RENAME identifier path_expression KW_TO path_expression

import_statement::=
      KW_IMPORT import_type path_expression_or_string opt_as_or_into_alias opt_options_list

module_statement::=
      KW_MODULE path_expression opt_options_list

column_ordering_and_options_expr::=
      expression opt_collate_clause opt_asc_or_desc opt_null_order opt_options_list

index_order_by_and_options_prefix::=
      '(' column_ordering_and_options_expr
    | index_order_by_and_options_prefix ',' column_ordering_and_options_expr

all_column_column_options::=
      index_order_by_and_options_prefix ')'

opt_with_column_options::=
      KW_WITH KW_COLUMN KW_OPTIONS all_column_column_options
    | /*%empty*/

index_all_columns::=
      '(' KW_ALL KW_COLUMNS opt_with_column_options ')'

index_order_by_and_options::=
      index_order_by_and_options_prefix ')'
    | index_all_columns

index_unnest_expression_list::=
      unnest_expression_with_opt_alias_and_offset
    | index_unnest_expression_list unnest_expression_with_opt_alias_and_offset

opt_index_unnest_expression_list::=
      index_unnest_expression_list
    | /*%empty*/

index_storing_expression_list_prefix::=
      '(' expression
    | index_storing_expression_list_prefix ',' expression

index_storing_expression_list::=
      index_storing_expression_list_prefix ')'

index_storing_list::=
      KW_STORING index_storing_expression_list

opt_index_storing_list::=
      index_storing_list
    | /*%empty*/

column_list_prefix::=
      '(' identifier
    | column_list_prefix ',' identifier

column_list::=
      column_list_prefix ')'

opt_column_list::=
      column_list
    | /*%empty*/

column_with_options::=
      identifier opt_options_list

column_with_options_list_prefix::=
      '(' column_with_options
    | column_with_options_list_prefix ',' column_with_options

column_with_options_list::=
      column_with_options_list_prefix ')'

opt_column_with_options_list::=
      column_with_options_list
    | /*%empty*/

grantee_list::=
      string_literal_or_parameter
    | grantee_list ',' string_literal_or_parameter

grantee_list_with_parens_prefix::=
      '(' string_literal_or_parameter
    | grantee_list_with_parens_prefix ',' string_literal_or_parameter

possibly_empty_grantee_list::=
      grantee_list_with_parens_prefix ')'
    | '(' ')'

show_statement::=
      KW_SHOW show_target opt_from_path_expression opt_like_string_literal

show_target::=
      KW_MATERIALIZED KW_VIEWS
    | identifier

opt_like_string_literal::=
      KW_LIKE string_literal
    | /*%empty*/

opt_like_path_expression::=
      KW_LIKE maybe_dashed_path_expression
    | /*%empty*/

opt_clone_table::=
      KW_CLONE clone_data_source
    | /*%empty*/

opt_copy_table::=
      KW_COPY copy_data_source
    | /*%empty*/

all_or_distinct::=
      KW_ALL
    | KW_DISTINCT

query_set_operation_type::=
      KW_UNION
    | KW_EXCEPT_IN_SET_OP
    | KW_INTERSECT

query_primary_or_set_operation::=
      query_primary
    | query_set_operation

parenthesized_query::=
      '(' query ')'

select_or_from_keyword::=
      KW_SELECT
    | KW_FROM

bad_keyword_after_from_query::=
      KW_WHERE
    | KW_SELECT
    | KW_GROUP

bad_keyword_after_from_query_allows_parens::=
      KW_ORDER
    | KW_UNION
    | KW_INTERSECT
    | KW_EXCEPT_IN_SET_OP
    | KW_LIMIT

query_without_pipe_operators::=
      with_clause query_primary_or_set_operation opt_order_by_clause opt_limit_offset_clause
    | with_clause_with_trailing_comma select_or_from_keyword
    | with_clause KW_PIPE
    | query_primary_or_set_operation opt_order_by_clause opt_limit_offset_clause
    | opt_with_clause from_clause
    | opt_with_clause from_clause bad_keyword_after_from_query
    | opt_with_clause from_clause bad_keyword_after_from_query_allows_parens

query::=
      query_without_pipe_operators
    | query KW_PIPE pipe_operator

pipe_operator::=
      pipe_where_clause
    | pipe_select_clause
    | pipe_extend_clause
    | pipe_rename
    | pipe_aggregate_clause
    | pipe_group_by
    | pipe_limit_offset_clause
    | pipe_set_operation_clause
    | pipe_order_by_clause
    | pipe_join
    | pipe_call
    | pipe_window_clause
    | pipe_distinct
    | pipe_tablesample
    | pipe_as
    | pipe_static_describe
    | pipe_assert
    | pipe_drop
    | pipe_set
    | pipe_pivot
    | pipe_unpivot

pipe_where_clause::=
      where_clause

pipe_select_clause::=
      select_clause

pipe_limit_offset_clause::=
      limit_offset_clause

pipe_order_by_clause::=
      order_by_clause_with_opt_comma

pipe_extend_clause::=
      KW_EXTEND pipe_selection_item_list

pipe_selection_item::=
      select_column_expr
    | select_column_dot_star

pipe_selection_item_with_order::=
      select_column_expr opt_selection_item_order
    | select_column_dot_star

pipe_selection_item_list_no_comma::=
      pipe_selection_item
    | pipe_selection_item_list_no_comma ',' pipe_selection_item

pipe_selection_item_list_no_comma_with_order::=
      pipe_selection_item_with_order
    | pipe_selection_item_list_no_comma_with_order ',' pipe_selection_item_with_order

pipe_selection_item_list::=
      pipe_selection_item_list_no_comma opt_comma

pipe_selection_item_list_with_order::=
      pipe_selection_item_list_no_comma_with_order opt_comma

pipe_selection_item_list_with_order_or_empty::=
      pipe_selection_item_list_with_order
    | /*%empty*/

pipe_rename_item::=
      identifier opt_as identifier
    | identifier '.'

pipe_rename_item_list::=
      pipe_rename_item
    | pipe_rename_item_list ',' pipe_rename_item

pipe_rename::=
      KW_RENAME pipe_rename_item_list opt_comma

opt_comma::=
      ','
    | /*%empty*/

pipe_aggregate_clause::=
      KW_AGGREGATE pipe_selection_item_list_with_order_or_empty opt_group_by_clause_with_opt_comma

pipe_group_by::=
      KW_GROUP

pipe_set_operation_clause::=
      set_operation_metadata parenthesized_query
    | pipe_set_operation_clause ',' parenthesized_query

pipe_join::=
      opt_natural join_type join_hint KW_JOIN opt_hint table_primary opt_on_or_using_clause

pipe_call::=
      KW_CALL tvf opt_as_alias

pipe_window_clause::=
      KW_WINDOW pipe_selection_item_list

pipe_distinct::=
      KW_DISTINCT

pipe_tablesample::=
      sample_clause

pipe_as::=
      KW_AS identifier

pipe_static_describe::=
      KW_STATIC_DESCRIBE

pipe_assert_base::=
      KW_ASSERT expression
    | pipe_assert_base ',' expression

pipe_assert::=
      pipe_assert_base opt_comma

identifier_in_pipe_drop::=
      identifier
    | identifier '.'

identifier_list_in_pipe_drop::=
      identifier_in_pipe_drop
    | identifier_list_in_pipe_drop ',' identifier_in_pipe_drop

pipe_drop::=
      KW_DROP identifier_list_in_pipe_drop opt_comma

pipe_set_item::=
      identifier '=' expression
    | identifier '.'

pipe_set_item_list::=
      pipe_set_item
    | pipe_set_item_list ',' pipe_set_item

pipe_set::=
      KW_SET pipe_set_item_list opt_comma

pipe_pivot::=
      pivot_clause opt_as_alias

pipe_unpivot::=
      unpivot_clause opt_as_alias

opt_corresponding_outer_mode::=
      KW_FULL_IN_SET_OP opt_outer
    | KW_OUTER
    | KW_LEFT_IN_SET_OP opt_outer
    | /*%empty*/

opt_strict::=
      KW_STRICT
    | /*%empty*/

opt_column_match_suffix::=
      KW_CORRESPONDING
    | KW_CORRESPONDING KW_BY column_list
    | /*%empty*/

query_set_operation_prefix::=
      query_primary set_operation_metadata query_primary
    | query_set_operation_prefix set_operation_metadata query_primary
    | query_primary set_operation_metadata KW_FROM
    | query_set_operation_prefix set_operation_metadata KW_FROM

set_operation_metadata::=
      opt_corresponding_outer_mode query_set_operation_type opt_hint all_or_distinct opt_strict opt_column_match_suffix

query_set_operation::=
      query_set_operation_prefix

query_primary::=
      select
    | parenthesized_query opt_as_alias_with_required_as

select_clause::=
      KW_SELECT opt_hint opt_select_with opt_all_or_distinct opt_select_as_clause select_list
    | KW_SELECT opt_hint opt_select_with opt_all_or_distinct opt_select_as_clause KW_FROM

select::=
      select_clause opt_from_clause opt_clauses_following_from

pre_select_with::=
      /*%empty*/

opt_select_with::=
      pre_select_with KW_WITH identifier
    | pre_select_with KW_WITH identifier KW_OPTIONS_IN_SELECT_WITH_OPTIONS options_list
    | pre_select_with

opt_select_as_clause::=
      KW_AS KW_STRUCT
    | KW_AS path_expression
    | /*%empty*/

extra_identifier_in_hints_name::=
      KW_HASH
    | KW_PROTO
    | KW_PARTITION

identifier_in_hints::=
      identifier
    | extra_identifier_in_hints_name

hint_entry::=
      identifier_in_hints '=' expression
    | identifier_in_hints '.' identifier_in_hints '=' expression

hint_with_body_prefix::=
      OPEN_INTEGER_PREFIX_HINT integer_literal KW_OPEN_HINT '{' hint_entry
    | KW_OPEN_HINT '{' hint_entry
    | hint_with_body_prefix ',' hint_entry

hint_with_body::=
      hint_with_body_prefix '}'

hint::=
      KW_OPEN_INTEGER_HINT integer_literal
    | hint_with_body

opt_all_or_distinct::=
      KW_ALL
    | KW_DISTINCT
    | /*%empty*/

select_list_prefix::=
      select_column
    | select_list_prefix ',' select_column

select_list::=
      select_list_prefix
    | select_list_prefix ','

star_except_list_prefix::=
      KW_EXCEPT '(' identifier
    | star_except_list_prefix ',' identifier

star_except_list::=
      star_except_list_prefix ')'

star_replace_item::=
      expression KW_AS identifier

star_modifiers_with_replace_prefix::=
      star_except_list KW_REPLACE '(' star_replace_item
    | KW_REPLACE '(' star_replace_item
    | star_modifiers_with_replace_prefix ',' star_replace_item

star_modifiers::=
      star_except_list
    | star_modifiers_with_replace_prefix ')'

select_column::=
      select_column_expr
    | select_column_dot_star
    | select_column_star

select_column_expr::=
      expression
    | select_column_expr_with_as_alias
    | expression identifier

select_list_prefix_with_as_aliases::=
      select_column_expr_with_as_alias
    | select_list_prefix_with_as_aliases ',' select_column_expr_with_as_alias

select_column_expr_with_as_alias::=
      expression KW_AS identifier

select_column_dot_star::=
      expression_higher_prec_than_and '.' '*'
    | expression_higher_prec_than_and '.' '*' star_modifiers

select_column_star::=
      '*'
    | '*' star_modifiers

opt_as_alias::=
      opt_as identifier
    | /*%empty*/

opt_as_alias_with_required_as::=
      KW_AS identifier
    | /*%empty*/

opt_as_or_into_alias::=
      KW_AS identifier
    | KW_INTO identifier
    | /*%empty*/

opt_as::=
      KW_AS
    | /*%empty*/

opt_natural::=
      KW_NATURAL
    | /*%empty*/

opt_outer::=
      KW_OUTER
    | /*%empty*/

int_literal_or_parameter::=
      integer_literal
    | parameter_expression
    | system_variable_expression

cast_int_literal_or_parameter::=
      KW_CAST '(' int_literal_or_parameter KW_AS type opt_format ')'

possibly_cast_int_literal_or_parameter::=
      cast_int_literal_or_parameter
    | int_literal_or_parameter

repeatable_clause::=
      KW_REPEATABLE '(' possibly_cast_int_literal_or_parameter ')'

sample_size_value::=
      possibly_cast_int_literal_or_parameter
    | floating_point_literal

sample_size_unit::=
      KW_ROWS
    | KW_PERCENT

sample_size::=
      sample_size_value sample_size_unit opt_partition_by_clause_no_hint

opt_repeatable_clause::=
      repeatable_clause
    | /*%empty*/

opt_sample_clause_suffix::=
      repeatable_clause
    | KW_WITH KW_WEIGHT opt_repeatable_clause
    | KW_WITH KW_WEIGHT identifier opt_repeatable_clause
    | KW_WITH KW_WEIGHT KW_AS identifier opt_repeatable_clause
    | /*%empty*/

sample_clause::=
      KW_TABLESAMPLE identifier '(' sample_size ')' opt_sample_clause_suffix

pivot_expression::=
      expression opt_as_alias

pivot_expression_list::=
      pivot_expression
    | pivot_expression_list ',' pivot_expression

pivot_value::=
      expression opt_as_alias

pivot_value_list::=
      pivot_value
    | pivot_value_list ',' pivot_value

pivot_clause::=
      KW_PIVOT '(' pivot_expression_list KW_FOR expression_higher_prec_than_and KW_IN '(' pivot_value_list ')' ')'

opt_as_string_or_integer::=
      opt_as string_literal
    | opt_as integer_literal
    | /*%empty*/

path_expression_list::=
      path_expression
    | path_expression_list ',' path_expression

path_expression_list_with_opt_parens::=
      '(' path_expression_list ')'
    | path_expression

path_expression_list_prefix::=
      '(' path_expression
    | path_expression_list_prefix ',' path_expression

path_expression_list_with_parens::=
      path_expression_list_prefix ')'

opt_path_expression_list_with_parens::=
      path_expression_list_with_parens
    | /*%empty*/

unpivot_in_item::=
      path_expression_list_with_opt_parens opt_as_string_or_integer

unpivot_in_item_list_prefix::=
      '(' unpivot_in_item
    | unpivot_in_item_list_prefix ',' unpivot_in_item

unpivot_in_item_list::=
      unpivot_in_item_list_prefix ')'

opt_unpivot_nulls_filter::=
      KW_EXCLUDE KW_NULLS
    | KW_INCLUDE KW_NULLS
    | /*%empty*/

unpivot_clause::=
      KW_UNPIVOT opt_unpivot_nulls_filter '(' path_expression_list_with_opt_parens KW_FOR path_expression KW_IN unpivot_in_item_list ')'

opt_pivot_or_unpivot_clause_and_alias::=
      KW_AS identifier
    | identifier
    | KW_AS identifier pivot_clause opt_as_alias
    | KW_AS identifier unpivot_clause opt_as_alias
    | KW_AS identifier qualify_clause_nonreserved
    | identifier pivot_clause opt_as_alias
    | identifier unpivot_clause opt_as_alias
    | identifier qualify_clause_nonreserved
    | pivot_clause opt_as_alias
    | unpivot_clause opt_as_alias
    | qualify_clause_nonreserved
    | /*%empty*/

match_recognize_clause::=
      KW_MATCH_RECOGNIZE_RESERVED '(' opt_partition_by_clause order_by_clause KW_MEASURES select_list_prefix_with_as_aliases KW_PATTERN '(' row_pattern_expr ')' KW_DEFINE with_expression_variable_prefix ')' opt_as_alias

row_pattern_expr::=
      row_pattern_concatenation
    | row_pattern_expr '|' row_pattern_concatenation

row_pattern_concatenation::=
      row_pattern_factor
    | row_pattern_concatenation row_pattern_factor

row_pattern_factor::=
      identifier
    | '(' row_pattern_expr ')'

table_subquery::=
      parenthesized_query opt_pivot_or_unpivot_clause_and_alias

table_clause::=
      KW_TABLE tvf_with_suffixes
    | KW_TABLE path_expression

model_clause::=
      KW_MODEL path_expression

connection_clause::=
      KW_CONNECTION path_expression_or_default

descriptor_column::=
      identifier

descriptor_column_list::=
      descriptor_column
    | descriptor_column_list ',' descriptor_column

descriptor_argument::=
      KW_DESCRIPTOR '(' descriptor_column_list ')'

tvf_argument::=
      expression
    | descriptor_argument
    | table_clause
    | model_clause
    | connection_clause
    | named_argument
    | '(' table_clause ')'
    | '(' model_clause ')'
    | '(' connection_clause ')'
    | '(' named_argument ')'
    | KW_SELECT
    | KW_WITH

tvf_prefix_no_args::=
      path_expression '('
    | KW_IF '('

tvf_prefix::=
      tvf_prefix_no_args tvf_argument
    | tvf_prefix ',' tvf_argument

tvf::=
      tvf_prefix_no_args ')' opt_hint
    | tvf_prefix ')' opt_hint

tvf_with_suffixes::=
      tvf_prefix_no_args ')' opt_hint opt_pivot_or_unpivot_clause_and_alias
    | tvf_prefix ')' opt_hint opt_pivot_or_unpivot_clause_and_alias

table_path_expression_base::=
      unnest_expression
    | maybe_slashed_or_dashed_path_expression
    | path_expression '['
    | path_expression '.' '('
    | unnest_expression '['
    | unnest_expression '.' '('

table_path_expression::=
      table_path_expression_base opt_hint opt_pivot_or_unpivot_clause_and_alias opt_with_offset_and_alias opt_at_system_time

table_primary::=
      tvf_with_suffixes
    | table_path_expression
    | '(' join ')'
    | table_subquery
    | table_primary match_recognize_clause
    | table_primary sample_clause

opt_at_system_time::=
      KW_FOR KW_SYSTEM KW_TIME KW_AS KW_OF expression
    | KW_FOR KW_SYSTEM_TIME KW_AS KW_OF expression
    | /*%empty*/

on_clause::=
      KW_ON expression

using_clause_prefix::=
      KW_USING '(' identifier
    | using_clause_prefix ',' identifier

using_clause::=
      using_clause_prefix ')'

opt_on_or_using_clause_list::=
      on_or_using_clause_list
    | /*%empty*/

on_or_using_clause_list::=
      on_or_using_clause
    | on_or_using_clause_list on_or_using_clause

on_or_using_clause::=
      on_clause
    | using_clause

opt_on_or_using_clause::=
      on_or_using_clause
    | /*%empty*/

join_type::=
      KW_CROSS
    | KW_FULL opt_outer
    | KW_INNER
    | KW_LEFT opt_outer
    | KW_RIGHT opt_outer
    | /*%empty*/

join_hint::=
      KW_HASH
    | KW_LOOKUP
    | /*%empty*/

join_input::=
      join
    | table_primary

join::=
      join_input opt_natural join_type join_hint KW_JOIN opt_hint table_primary opt_on_or_using_clause_list

from_clause_contents::=
      table_primary
    | from_clause_contents ',' table_primary
    | from_clause_contents opt_natural join_type join_hint KW_JOIN opt_hint table_primary opt_on_or_using_clause_list
    | '@'
    | '?'
    | KW_DOUBLE_AT

opt_from_clause::=
      from_clause
    | /*%empty*/

from_clause::=
      KW_FROM from_clause_contents

opt_clauses_following_from::=
      where_clause opt_group_by_clause opt_having_clause opt_qualify_clause opt_window_clause
    | opt_clauses_following_where

opt_clauses_following_where::=
      group_by_clause opt_having_clause opt_qualify_clause opt_window_clause
    | opt_clauses_following_group_by

opt_clauses_following_group_by::=
      having_clause opt_qualify_clause opt_window_clause
    | opt_qualify_clause_reserved opt_window_clause

where_clause::=
      KW_WHERE expression

opt_where_clause::=
      where_clause
    | /*%empty*/

rollup_list::=
      KW_ROLLUP '(' expression
    | rollup_list ',' expression

cube_list::=
      KW_CUBE '(' expression
    | cube_list ',' expression

grouping_set::=
      '(' ')'
    | expression
    | rollup_list ')'
    | cube_list ')'

grouping_set_list::=
      KW_GROUPING KW_SETS '(' grouping_set
    | grouping_set_list ',' grouping_set

opt_selection_item_order::=
      asc_or_desc opt_null_order
    | /*%empty*/

opt_grouping_item_order::=
      opt_selection_item_order
    | null_order

grouping_item::=
      '(' ')'
    | expression opt_as_alias_with_required_as opt_grouping_item_order
    | rollup_list ')'
    | cube_list ')'
    | grouping_set_list ')'

opt_and_order::=
      KW_AND KW_ORDER
    | /*%empty*/

group_by_preamble::=
      KW_GROUP opt_hint opt_and_order KW_BY

group_by_clause_prefix::=
      group_by_preamble grouping_item
    | group_by_clause_prefix ',' grouping_item

group_by_all::=
      group_by_preamble KW_ALL

group_by_clause::=
      group_by_all
    | group_by_clause_prefix

opt_group_by_clause::=
      group_by_clause
    | /*%empty*/

opt_group_by_clause_with_opt_comma::=
      group_by_clause_prefix opt_comma
    | /*%empty*/

having_clause::=
      KW_HAVING expression

opt_having_clause::=
      having_clause
    | /*%empty*/

window_definition::=
      identifier KW_AS window_specification

window_clause_prefix::=
      KW_WINDOW window_definition
    | window_clause_prefix ',' window_definition

opt_window_clause::=
      window_clause_prefix
    | /*%empty*/

opt_qualify_clause::=
      qualify_clause_reserved
    | qualify_clause_nonreserved
    | /*%empty*/

qualify_clause_reserved::=
      KW_QUALIFY_RESERVED expression

opt_qualify_clause_reserved::=
      qualify_clause_reserved
    | /*%empty*/

qualify_clause_nonreserved::=
      KW_QUALIFY_NONRESERVED expression

limit_offset_clause::=
      KW_LIMIT expression KW_OFFSET expression
    | KW_LIMIT expression

opt_limit_offset_clause::=
      limit_offset_clause
    | /*%empty*/

opt_having_or_group_by_modifier::=
      KW_HAVING KW_MAX expression
    | KW_HAVING KW_MIN expression
    | group_by_clause_prefix
    | /*%empty*/

opt_clamped_between_modifier::=
      KW_CLAMPED KW_BETWEEN expression_higher_prec_than_and KW_AND expression
    | /*%empty*/

opt_with_report_modifier::=
      KW_WITH KW_REPORT opt_with_report_format
    | /*%empty*/

opt_with_report_format::=
      options_list
    | /*%empty*/

opt_null_handling_modifier::=
      KW_IGNORE KW_NULLS
    | KW_RESPECT KW_NULLS
    | /*%empty*/

possibly_unbounded_int_literal_or_parameter::=
      int_literal_or_parameter
    | KW_UNBOUNDED

recursion_depth_modifier::=
      KW_WITH KW_DEPTH opt_as_alias_with_required_as
    | KW_WITH KW_DEPTH opt_as_alias_with_required_as KW_BETWEEN possibly_unbounded_int_literal_or_parameter KW_AND possibly_unbounded_int_literal_or_parameter
    | KW_WITH KW_DEPTH opt_as_alias_with_required_as KW_MAX possibly_unbounded_int_literal_or_parameter

aliased_query_modifiers::=
      recursion_depth_modifier
    | /*%empty*/

aliased_query::=
      identifier KW_AS parenthesized_query aliased_query_modifiers

aliased_query_list::=
      aliased_query
    | aliased_query_list ',' aliased_query

with_clause::=
      KW_WITH aliased_query
    | KW_WITH KW_RECURSIVE aliased_query
    | with_clause ',' aliased_query

opt_with_clause::=
      with_clause
    | /*%empty*/

opt_with_connection_clause::=
      with_connection_clause
    | /*%empty*/

with_clause_with_trailing_comma::=
      with_clause ','

asc_or_desc::=
      KW_ASC
    | KW_DESC

opt_asc_or_desc::=
      asc_or_desc
    | /*%empty*/

null_order::=
      KW_NULLS KW_FIRST
    | KW_NULLS KW_LAST

opt_null_order::=
      null_order
    | /*%empty*/

string_literal_or_parameter::=
      string_literal
    | parameter_expression
    | system_variable_expression

collate_clause::=
      KW_COLLATE string_literal_or_parameter

opt_collate_clause::=
      collate_clause
    | /*%empty*/

opt_default_collate_clause::=
      KW_DEFAULT collate_clause
    | /*%empty*/

ordering_expression::=
      expression opt_collate_clause opt_asc_or_desc opt_null_order

order_by_clause_prefix::=
      KW_ORDER opt_hint KW_BY ordering_expression
    | order_by_clause_prefix ',' ordering_expression

order_by_clause::=
      order_by_clause_prefix

order_by_clause_with_opt_comma::=
      order_by_clause_prefix opt_comma

opt_order_by_clause::=
      order_by_clause
    | /*%empty*/

parenthesized_in_rhs::=
      parenthesized_query
    | '(' expression_maybe_parenthesized_not_a_query ')'
    | in_list_two_or_more_prefix ')'

parenthesized_anysomeall_list_in_rhs::=
      parenthesized_query
    | '(' expression_maybe_parenthesized_not_a_query ')'
    | in_list_two_or_more_prefix ')'

in_list_two_or_more_prefix::=
      '(' expression ',' expression
    | in_list_two_or_more_prefix ',' expression

expression_with_opt_alias::=
      expression opt_as_alias_with_required_as

unnest_expression_prefix::=
      KW_UNNEST '(' expression_with_opt_alias
    | unnest_expression_prefix ',' expression_with_opt_alias

opt_array_zip_mode::=
      ',' named_argument
    | /*%empty*/

unnest_expression::=
      unnest_expression_prefix opt_array_zip_mode ')'
    | KW_UNNEST '(' KW_SELECT

unnest_expression_with_opt_alias_and_offset::=
      unnest_expression opt_as_alias opt_with_offset_and_alias

comparative_operator::=
      '='
    | KW_NOT_EQUALS_C_STYLE
    | KW_NOT_EQUALS_SQL_STYLE
    | '<'
    | KW_LESS_EQUALS
    | '>'
    | KW_GREATER_EQUALS

additive_operator::=
      '+'
    | '-'

multiplicative_operator::=
      '*'
    | '/'

shift_operator::=
      KW_SHIFT_LEFT
    | KW_SHIFT_RIGHT

import_type::=
      KW_MODULE
    | KW_PROTO

any_some_all::=
      KW_ANY
    | KW_SOME
    | KW_ALL

like_operator::=
      KW_LIKE
    | KW_NOT_SPECIAL KW_LIKE

between_operator::=
      KW_BETWEEN
    | KW_NOT_SPECIAL KW_BETWEEN

distinct_operator::=
      KW_IS KW_DISTINCT KW_FROM
    | KW_IS KW_NOT_SPECIAL KW_DISTINCT KW_FROM

in_operator::=
      KW_IN
    | KW_NOT_SPECIAL KW_IN

is_operator::=
      KW_IS
    | KW_IS KW_NOT

unary_operator::=
      '+'
    | '-'
    | '~'

with_expression_variable::=
      identifier KW_AS expression

with_expression_variable_prefix::=
      with_expression_variable
    | with_expression_variable_prefix ',' with_expression_variable

with_expression::=
      KW_WITH_STARTING_WITH_EXPRESSION '(' with_expression_variable_prefix ',' expression ')'

expression::=
      expression_higher_prec_than_and
    | and_expression
    | or_expression

or_expression::=
      expression KW_OR expression

and_expression::=
      and_expression KW_AND expression_higher_prec_than_and
    | expression_higher_prec_than_and KW_AND expression_higher_prec_than_and

expression_higher_prec_than_and::=
      unparenthesized_expression_higher_prec_than_and
    | parenthesized_expression_not_a_query
    | parenthesized_query

expression_maybe_parenthesized_not_a_query::=
      parenthesized_expression_not_a_query
    | unparenthesized_expression_higher_prec_than_and
    | and_expression
    | or_expression

parenthesized_expression_not_a_query::=
      '(' expression_maybe_parenthesized_not_a_query ')'

unparenthesized_expression_higher_prec_than_and::=
      null_literal
    | boolean_literal
    | string_literal
    | bytes_literal
    | integer_literal
    | numeric_literal
    | bignumeric_literal
    | json_literal
    | floating_point_literal
    | date_or_time_literal
    | range_literal
    | parameter_expression
    | system_variable_expression
    | array_constructor
    | new_constructor
    | braced_constructor
    | braced_new_constructor
    | struct_braced_constructor
    | case_expression
    | cast_expression
    | extract_expression
    | with_expression
    | replace_fields_expression
    | function_call_expression_with_clauses
    | interval_expression
    | identifier
    | struct_constructor
    | expression_subquery_with_keyword
    | expression_higher_prec_than_and '[' expression ']'
    | expression_higher_prec_than_and '.' '(' path_expression ')'
    | expression_higher_prec_than_and '.' identifier
    | KW_NOT expression_higher_prec_than_and
    | expression_higher_prec_than_and like_operator any_some_all opt_hint unnest_expression
    | expression_higher_prec_than_and like_operator any_some_all opt_hint parenthesized_anysomeall_list_in_rhs
    | expression_higher_prec_than_and like_operator expression_higher_prec_than_and
    | expression_higher_prec_than_and distinct_operator expression_higher_prec_than_and
    | expression_higher_prec_than_and in_operator opt_hint unnest_expression
    | expression_higher_prec_than_and in_operator opt_hint parenthesized_in_rhs
    | expression_higher_prec_than_and between_operator expression_higher_prec_than_and KW_AND expression_higher_prec_than_and
    | expression_higher_prec_than_and between_operator expression_higher_prec_than_and KW_OR
    | expression_higher_prec_than_and is_operator KW_UNKNOWN
    | expression_higher_prec_than_and is_operator null_literal
    | expression_higher_prec_than_and is_operator boolean_literal
    | expression_higher_prec_than_and comparative_operator expression_higher_prec_than_and
    | expression_higher_prec_than_and '|' expression_higher_prec_than_and
    | expression_higher_prec_than_and '^' expression_higher_prec_than_and
    | expression_higher_prec_than_and '&' expression_higher_prec_than_and
    | expression_higher_prec_than_and KW_CONCAT_OP expression_higher_prec_than_and
    | expression_higher_prec_than_and shift_operator expression_higher_prec_than_and
    | expression_higher_prec_than_and additive_operator expression_higher_prec_than_and
    | expression_higher_prec_than_and multiplicative_operator expression_higher_prec_than_and
    | unary_operator expression_higher_prec_than_and

path_expression::=
      identifier
    | path_expression '.' identifier

dashed_identifier::=
      identifier '-' identifier
    | dashed_identifier '-' identifier
    | identifier '-' INTEGER_LITERAL
    | dashed_identifier '-' INTEGER_LITERAL
    | identifier '-' FLOATING_POINT_LITERAL identifier
    | dashed_identifier '-' FLOATING_POINT_LITERAL identifier

dashed_path_expression::=
      dashed_identifier
    | dashed_path_expression '.' identifier

maybe_dashed_path_expression::=
      path_expression
    | dashed_path_expression

maybe_slashed_or_dashed_path_expression::=
      maybe_dashed_path_expression
    | slashed_path_expression

slashed_identifier_separator::=
      '-'
    | '/'
    | ':'

identifier_or_integer::=
      identifier
    | INTEGER_LITERAL
    | SCRIPT_LABEL

slashed_identifier::=
      '/' identifier_or_integer
    | slashed_identifier slashed_identifier_separator identifier_or_integer
    | slashed_identifier slashed_identifier_separator FLOATING_POINT_LITERAL slashed_identifier_separator identifier_or_integer

slashed_path_expression::=
      slashed_identifier
    | slashed_identifier slashed_identifier_separator FLOATING_POINT_LITERAL identifier
    | slashed_identifier slashed_identifier_separator FLOATING_POINT_LITERAL '.' identifier
    | slashed_path_expression '.' identifier

array_constructor_prefix_no_expressions::=
      KW_ARRAY '['
    | '['
    | array_type '['

array_constructor_prefix::=
      array_constructor_prefix_no_expressions expression
    | array_constructor_prefix ',' expression

array_constructor::=
      array_constructor_prefix_no_expressions ']'
    | array_constructor_prefix ']'

range_literal::=
      range_type string_literal

date_or_time_literal_kind::=
      KW_DATE
    | KW_DATETIME
    | KW_TIME
    | KW_TIMESTAMP

date_or_time_literal::=
      date_or_time_literal_kind string_literal

interval_expression::=
      KW_INTERVAL expression identifier
    | KW_INTERVAL expression identifier KW_TO identifier

parameter_expression::=
      named_parameter_expression
    | '?'

named_parameter_expression::=
      '@' identifier

type_name::=
      path_expression
    | KW_INTERVAL

template_type_open::=
      '<'

template_type_close::=
      '>'

array_type::=
      KW_ARRAY template_type_open type template_type_close

struct_field::=
      identifier type
    | type

struct_type_prefix::=
      KW_STRUCT template_type_open struct_field
    | struct_type_prefix ',' struct_field

struct_type::=
      KW_STRUCT template_type_open template_type_close
    | struct_type_prefix template_type_close

range_type::=
      KW_RANGE template_type_open type template_type_close

function_type_prefix::=
      KW_FUNCTION template_type_open '(' type
    | function_type_prefix ',' type

function_type::=
      KW_FUNCTION template_type_open '(' ')' KW_LAMBDA_ARROW type template_type_close
    | KW_FUNCTION template_type_open type KW_LAMBDA_ARROW type template_type_close
    | function_type_prefix ')' KW_LAMBDA_ARROW type template_type_close

map_type::=
      KW_MAP template_type_open type ',' type template_type_close

raw_type::=
      array_type
    | struct_type
    | type_name
    | range_type
    | function_type
    | map_type

type_parameter::=
      integer_literal
    | boolean_literal
    | string_literal
    | bytes_literal
    | floating_point_literal
    | KW_MAX

type_parameters_prefix::=
      '(' type_parameter
    | type_parameters_prefix ',' type_parameter

opt_type_parameters::=
      type_parameters_prefix ')'
    | type_parameters_prefix ',' ')'
    | /*%empty*/

type::=
      raw_type opt_type_parameters opt_collate_clause

templated_parameter_kind::=
      KW_PROTO
    | KW_ENUM
    | KW_STRUCT
    | KW_ARRAY
    | identifier

templated_parameter_type::=
      KW_ANY templated_parameter_kind

type_or_tvf_schema::=
      type
    | templated_parameter_type
    | tvf_schema

new_constructor_prefix_no_arg::=
      KW_NEW type_name '('

new_constructor_arg::=
      expression
    | expression KW_AS identifier
    | expression KW_AS '(' path_expression ')'

new_constructor_prefix::=
      new_constructor_prefix_no_arg new_constructor_arg
    | new_constructor_prefix ',' new_constructor_arg

new_constructor::=
      new_constructor_prefix ')'
    | new_constructor_prefix_no_arg ')'

braced_constructor_field_value::=
      ':' expression
    | braced_constructor

braced_constructor_extension_expression_start::=
      '(' path_expression ')'

braced_constructor_extension_expression::=
      braced_constructor_extension_expression_start

braced_constructor_extension_lhs::=
      braced_constructor_extension_expression

braced_constructor_extension::=
      braced_constructor_extension_lhs braced_constructor_field_value

braced_constructor_lhs::=
      generalized_path_expression

braced_constructor_field::=
      braced_constructor_lhs braced_constructor_field_value

braced_constructor_start::=
      '{'

braced_constructor_prefix::=
      braced_constructor_start braced_constructor_field
    | braced_constructor_start braced_constructor_extension
    | braced_constructor_prefix ',' braced_constructor_field
    | braced_constructor_prefix braced_constructor_field
    | braced_constructor_prefix ',' braced_constructor_extension

braced_constructor::=
      braced_constructor_start '}'
    | braced_constructor_prefix '}'
    | braced_constructor_prefix ',' '}'

braced_new_constructor::=
      KW_NEW type_name braced_constructor

struct_braced_constructor::=
      struct_type braced_constructor
    | KW_STRUCT braced_constructor

case_no_value_expression_prefix::=
      KW_CASE KW_WHEN expression KW_THEN expression
    | case_no_value_expression_prefix KW_WHEN expression KW_THEN expression

case_value_expression_prefix::=
      KW_CASE expression KW_WHEN expression KW_THEN expression
    | case_value_expression_prefix KW_WHEN expression KW_THEN expression

case_expression_prefix::=
      case_no_value_expression_prefix
    | case_value_expression_prefix

case_expression::=
      case_expression_prefix KW_END
    | case_expression_prefix KW_ELSE expression KW_END

opt_at_time_zone::=
      KW_AT KW_TIME KW_ZONE expression
    | /*%empty*/

opt_format::=
      KW_FORMAT expression opt_at_time_zone
    | /*%empty*/

cast_expression::=
      KW_CAST '(' expression KW_AS type opt_format ')'
    | KW_CAST '(' KW_SELECT
    | KW_SAFE_CAST '(' expression KW_AS type opt_format ')'
    | KW_SAFE_CAST '(' KW_SELECT

extract_expression_base::=
      KW_EXTRACT '(' expression KW_FROM expression

extract_expression::=
      extract_expression_base ')'
    | extract_expression_base KW_AT KW_TIME KW_ZONE expression ')'

replace_fields_arg::=
      expression KW_AS generalized_path_expression
    | expression KW_AS generalized_extension_path

replace_fields_prefix::=
      KW_REPLACE_FIELDS '(' expression ',' replace_fields_arg
    | replace_fields_prefix ',' replace_fields_arg

replace_fields_expression::=
      replace_fields_prefix ')'

function_name_from_keyword::=
      KW_IF
    | KW_GROUPING
    | KW_LEFT
    | KW_RIGHT
    | KW_COLLATE
    | KW_RANGE

function_call_expression_base::=
      expression_higher_prec_than_and '(' KW_DISTINCT
    | expression_higher_prec_than_and '('
    | function_name_from_keyword '('

function_call_argument::=
      expression opt_as_alias_with_required_as
    | named_argument
    | lambda_argument
    | sequence_arg
    | KW_SELECT

sequence_arg::=
      KW_SEQUENCE path_expression

named_argument::=
      identifier KW_NAMED_ARGUMENT_ASSIGNMENT expression
    | identifier KW_NAMED_ARGUMENT_ASSIGNMENT lambda_argument

lambda_argument::=
      lambda_argument_list KW_LAMBDA_ARROW expression

lambda_argument_list::=
      expression
    | '(' ')'

function_call_expression_with_args_prefix::=
      function_call_expression_base function_call_argument
    | function_call_expression_base '*'
    | function_call_expression_with_args_prefix ',' function_call_argument

function_call_expression::=
      function_call_expression_base opt_having_or_group_by_modifier opt_order_by_clause opt_limit_offset_clause ')'
    | function_call_expression_with_args_prefix opt_null_handling_modifier opt_having_or_group_by_modifier opt_clamped_between_modifier opt_with_report_modifier opt_order_by_clause opt_limit_offset_clause ')'

opt_identifier::=
      identifier
    | /*%empty*/

partition_by_clause_prefix::=
      KW_PARTITION opt_hint KW_BY expression
    | partition_by_clause_prefix ',' expression

opt_partition_by_clause::=
      partition_by_clause_prefix
    | /*%empty*/

partition_by_clause_prefix_no_hint::=
      KW_PARTITION KW_BY expression
    | partition_by_clause_prefix_no_hint ',' expression

opt_partition_by_clause_no_hint::=
      partition_by_clause_prefix_no_hint
    | /*%empty*/

cluster_by_clause_prefix_no_hint::=
      KW_CLUSTER KW_BY expression
    | cluster_by_clause_prefix_no_hint ',' expression

opt_cluster_by_clause_no_hint::=
      cluster_by_clause_prefix_no_hint
    | /*%empty*/

opt_ttl_clause::=
      KW_ROW KW_DELETION KW_POLICY '(' expression ')'
    | /*%empty*/

preceding_or_following::=
      KW_PRECEDING
    | KW_FOLLOWING

window_frame_bound::=
      KW_UNBOUNDED preceding_or_following
    | KW_CURRENT KW_ROW
    | expression preceding_or_following

frame_unit::=
      KW_ROWS
    | KW_RANGE

opt_window_frame_clause::=
      frame_unit KW_BETWEEN window_frame_bound KW_AND window_frame_bound
    | frame_unit window_frame_bound
    | /*%empty*/

window_specification::=
      identifier
    | '(' opt_identifier opt_partition_by_clause opt_order_by_clause opt_window_frame_clause ')'

function_call_expression_with_clauses::=
      function_call_expression opt_hint opt_with_group_rows opt_over_clause

opt_with_group_rows::=
      KW_WITH_STARTING_WITH_GROUP_ROWS KW_GROUP KW_ROWS parenthesized_query
    | /*%empty*/

opt_over_clause::=
      KW_OVER window_specification
    | /*%empty*/

struct_constructor_prefix_with_keyword_no_arg::=
      struct_type '('
    | KW_STRUCT '('

struct_constructor_prefix_with_keyword::=
      struct_constructor_prefix_with_keyword_no_arg struct_constructor_arg
    | struct_constructor_prefix_with_keyword ',' struct_constructor_arg

struct_constructor_arg::=
      expression opt_as_alias_with_required_as

struct_constructor_prefix_without_keyword::=
      '(' expression ',' expression
    | struct_constructor_prefix_without_keyword ',' expression

struct_constructor::=
      struct_constructor_prefix_with_keyword ')'
    | struct_constructor_prefix_with_keyword_no_arg ')'
    | struct_constructor_prefix_without_keyword ')'

expression_subquery_with_keyword::=
      KW_ARRAY parenthesized_query
    | KW_EXISTS opt_hint parenthesized_query

null_literal::=
      KW_NULL

boolean_literal::=
      KW_TRUE
    | KW_FALSE

string_literal_component::=
      STRING_LITERAL

string_literal::=
      string_literal_component
    | string_literal string_literal_component
    | string_literal bytes_literal_component

bytes_literal_component::=
      BYTES_LITERAL

bytes_literal::=
      bytes_literal_component
    | bytes_literal bytes_literal_component
    | bytes_literal string_literal_component

integer_literal::=
      INTEGER_LITERAL

numeric_literal_prefix::=
      KW_NUMERIC
    | KW_DECIMAL

numeric_literal::=
      numeric_literal_prefix string_literal

bignumeric_literal_prefix::=
      KW_BIGNUMERIC
    | KW_BIGDECIMAL

bignumeric_literal::=
      bignumeric_literal_prefix string_literal

json_literal::=
      KW_JSON string_literal

floating_point_literal::=
      FLOATING_POINT_LITERAL

token_identifier::=
      IDENTIFIER

identifier::=
      token_identifier
    | keyword_as_identifier

label::=
      SCRIPT_LABEL

system_variable_expression::=
      KW_DOUBLE_AT path_expression

common_keyword_as_identifier::=
      KW_ABORT
    | KW_ACCESS
    | KW_ACTION
    | KW_AGGREGATE
    | KW_ADD
    | KW_ALTER
    | KW_ALWAYS
    | KW_ANALYZE
    | KW_APPROX
    | KW_ARE
    | KW_ASSERT
    | KW_BATCH
    | KW_BEGIN
    | KW_BIGDECIMAL
    | KW_BIGNUMERIC
    | KW_BREAK
    | KW_CALL
    | KW_CASCADE
    | KW_CHECK
    | KW_CLAMPED
    | KW_CLONE
    | KW_COPY
    | KW_CLUSTER
    | KW_COLUMN
    | KW_COLUMNS
    | KW_COMMIT
    | KW_CONNECTION
    | KW_CONSTANT
    | KW_CONSTRAINT
    | KW_CONTINUE
    | KW_CORRESPONDING
    | KW_CYCLE
    | KW_DATA
    | KW_DATABASE
    | KW_DATE
    | KW_DATETIME
    | KW_DECIMAL
    | KW_DECLARE
    | KW_DEFINER
    | KW_DELETE
    | KW_DELETION
    | KW_DEPTH
    | KW_DESCRIBE
    | KW_DETERMINISTIC
    | KW_DO
    | KW_DROP
    | KW_ELSEIF
    | KW_ENFORCED
    | KW_ERROR
    | KW_EXCEPTION
    | KW_EXECUTE
    | KW_EXPLAIN
    | KW_EXPORT
    | KW_EXTEND
    | KW_EXTERNAL
    | KW_FILES
    | KW_FILTER
    | KW_FILL
    | KW_FIRST
    | KW_FOREIGN
    | KW_FORMAT
    | KW_FUNCTION
    | KW_GENERATED
    | KW_GRANT
    | KW_GROUP_ROWS
    | KW_HIDDEN
    | KW_IDENTITY
    | KW_IMMEDIATE
    | KW_IMMUTABLE
    | KW_IMPORT
    | KW_INCLUDE
    | KW_INCREMENT
    | KW_INDEX
    | KW_INOUT
    | KW_INPUT
    | KW_INSERT
    | KW_INVOKER
    | KW_ISOLATION
    | KW_ITERATE
    | KW_JSON
    | KW_KEY
    | KW_LANGUAGE
    | KW_LAST
    | KW_LEAVE
    | KW_LEVEL
    | KW_LOAD
    | KW_LOOP
    | KW_MACRO
    | KW_MAP
    | KW_MATCH
    | KW_MATCH_RECOGNIZE_NONRESERVED
    | KW_MATCHED
    | KW_MATERIALIZED
    | KW_MAX
    | KW_MAXVALUE
    | KW_MEASURES
    | KW_MESSAGE
    | KW_METADATA
    | KW_MIN
    | KW_MINVALUE
    | KW_MODEL
    | KW_MODULE
    | KW_NUMERIC
    | KW_OFFSET
    | KW_ONLY
    | KW_OPTIONS
    | KW_OUT
    | KW_OUTPUT
    | KW_OVERWRITE
    | KW_PARTITIONS
    | KW_PATTERN
    | KW_PERCENT
    | KW_PIVOT
    | KW_POLICIES
    | KW_POLICY
    | KW_PRIMARY
    | KW_PRIVATE
    | KW_PRIVILEGE
    | KW_PRIVILEGES
    | KW_PROCEDURE
    | KW_PROJECT
    | KW_PUBLIC
    | KW_QUALIFY_NONRESERVED
    | KW_RAISE
    | KW_READ
    | KW_REFERENCES
    | KW_REMOTE
    | KW_REMOVE
    | KW_RENAME
    | KW_REPEAT
    | KW_REPEATABLE
    | KW_REPLACE
    | KW_REPLACE_FIELDS
    | KW_REPLICA
    | KW_REPORT
    | KW_RESTRICT
    | KW_RESTRICTION
    | KW_RETURNS
    | KW_RETURN
    | KW_REVOKE
    | KW_ROLLBACK
    | KW_ROW
    | KW_RUN
    | KW_SAFE_CAST
    | KW_SCHEMA
    | KW_SEARCH
    | KW_SECURITY
    | KW_SEQUENCE
    | KW_SETS
    | KW_SHOW
    | KW_SNAPSHOT
    | KW_SOURCE
    | KW_SQL
    | KW_STABLE
    | KW_START
    | KW_STATIC_DESCRIBE
    | KW_STORED
    | KW_STORING
    | KW_STRICT
    | KW_SYSTEM
    | KW_SYSTEM_TIME
    | KW_TABLE
    | KW_TABLES
    | KW_TARGET
    | KW_TEMP
    | KW_TEMPORARY
    | KW_TIME
    | KW_TIMESTAMP
    | KW_TRANSACTION
    | KW_TRANSFORM
    | KW_TRUNCATE
    | KW_TYPE
    | KW_UNDROP
    | KW_UNIQUE
    | KW_UNKNOWN
    | KW_UNPIVOT
    | KW_UNTIL
    | KW_UPDATE
    | KW_VALUE
    | KW_VALUES
    | KW_VECTOR
    | KW_VIEW
    | KW_VIEWS
    | KW_VOLATILE
    | KW_WEIGHT
    | KW_WHILE
    | KW_WRITE
    | KW_ZONE
    | KW_DESCRIPTOR
    | KW_INTERLEAVE
    | KW_NULL_FILTERED
    | KW_PARENT

keyword_as_identifier::=
      common_keyword_as_identifier
    | KW_SIMPLE

opt_or_replace::=
      KW_OR KW_REPLACE
    | /*%empty*/

opt_create_scope::=
      KW_TEMP
    | KW_TEMPORARY
    | KW_PUBLIC
    | KW_PRIVATE
    | /*%empty*/

opt_unique::=
      KW_UNIQUE
    | /*%empty*/

describe_keyword::=
      KW_DESCRIBE
    | KW_DESC

opt_hint::=
      hint
    | /*%empty*/

options_entry::=
      identifier_in_hints options_assignment_operator expression_or_proto

options_assignment_operator::=
      '='
    | KW_ADD_ASSIGN
    | KW_SUB_ASSIGN

expression_or_proto::=
      KW_PROTO
    | expression

options_list_prefix::=
      '(' options_entry
    | options_list_prefix ',' options_entry

options_list::=
      options_list_prefix ')'
    | '(' ')'

options::=
      KW_OPTIONS options_list

opt_options_list::=
      options
    | /*%empty*/

define_table_statement::=
      KW_DEFINE KW_TABLE path_expression options_list

dml_statement::=
      insert_statement
    | delete_statement
    | update_statement

opt_from_keyword::=
      KW_FROM
    | /*%empty*/

opt_where_expression::=
      KW_WHERE expression
    | /*%empty*/

opt_assert_rows_modified::=
      KW_ASSERT_ROWS_MODIFIED possibly_cast_int_literal_or_parameter
    | /*%empty*/

opt_returning_clause::=
      KW_THEN KW_RETURN select_list
    | KW_THEN KW_RETURN KW_WITH KW_ACTION select_list
    | KW_THEN KW_RETURN KW_WITH KW_ACTION KW_AS identifier select_list
    | /*%empty*/

opt_or_ignore_replace_update::=
      KW_OR KW_IGNORE
    | KW_IGNORE
    | KW_OR KW_REPLACE
    | KW_REPLACE_AFTER_INSERT
    | KW_OR KW_UPDATE
    | KW_UPDATE_AFTER_INSERT
    | /*%empty*/

insert_statement_prefix::=
      KW_INSERT opt_or_ignore_replace_update opt_into maybe_dashed_generalized_path_expression opt_hint

insert_statement::=
      insert_statement_prefix column_list insert_values_or_query opt_assert_rows_modified opt_returning_clause
    | insert_statement_prefix insert_values_or_query opt_assert_rows_modified opt_returning_clause

copy_data_source::=
      maybe_dashed_path_expression opt_at_system_time opt_where_clause

clone_data_source::=
      maybe_dashed_path_expression opt_at_system_time opt_where_clause

clone_data_source_list::=
      clone_data_source
    | clone_data_source_list KW_UNION KW_ALL clone_data_source

clone_data_statement::=
      KW_CLONE KW_DATA KW_INTO maybe_dashed_path_expression KW_FROM clone_data_source_list

expression_or_default::=
      expression
    | KW_DEFAULT

insert_values_row_prefix::=
      '(' expression_or_default
    | insert_values_row_prefix ',' expression_or_default

insert_values_row::=
      insert_values_row_prefix ')'

insert_values_or_query::=
      insert_values_list
    | query

insert_values_list::=
      KW_VALUES insert_values_row
    | insert_values_list ',' insert_values_row

delete_statement::=
      KW_DELETE opt_from_keyword maybe_dashed_generalized_path_expression opt_hint opt_as_alias opt_with_offset_and_alias opt_where_expression opt_assert_rows_modified opt_returning_clause

opt_with_offset_and_alias::=
      KW_WITH KW_OFFSET opt_as_alias
    | /*%empty*/

update_statement::=
      KW_UPDATE maybe_dashed_generalized_path_expression opt_hint opt_as_alias opt_with_offset_and_alias KW_SET update_item_list opt_from_clause opt_where_expression opt_assert_rows_modified opt_returning_clause

truncate_statement::=
      KW_TRUNCATE KW_TABLE maybe_dashed_path_expression opt_where_expression

nested_dml_statement::=
      '(' dml_statement ')'

generalized_path_expression::=
      identifier
    | generalized_path_expression '.' generalized_extension_path
    | generalized_path_expression '.' identifier
    | generalized_path_expression '[' expression ']'

maybe_dashed_generalized_path_expression::=
      generalized_path_expression
    | dashed_path_expression

generalized_extension_path::=
      '(' path_expression ')'
    | generalized_extension_path '.' '(' path_expression ')'
    | generalized_extension_path '.' identifier

update_set_value::=
      generalized_path_expression '=' expression_or_default

update_item::=
      update_set_value
    | nested_dml_statement

update_item_list::=
      update_item
    | update_item_list ',' update_item

opt_into::=
      KW_INTO
    | /*%empty*/

opt_by_target::=
      KW_BY KW_TARGET
    | /*%empty*/

opt_and_expression::=
      KW_AND expression
    | /*%empty*/

merge_insert_value_list_or_source_row::=
      KW_VALUES insert_values_row
    | KW_ROW

merge_action::=
      KW_INSERT opt_column_list merge_insert_value_list_or_source_row
    | KW_UPDATE KW_SET update_item_list
    | KW_DELETE

merge_when_clause::=
      KW_WHEN KW_MATCHED opt_and_expression KW_THEN merge_action
    | KW_WHEN KW_NOT KW_MATCHED opt_by_target opt_and_expression KW_THEN merge_action
    | KW_WHEN KW_NOT KW_MATCHED KW_BY KW_SOURCE opt_and_expression KW_THEN merge_action

merge_when_clause_list::=
      merge_when_clause
    | merge_when_clause_list merge_when_clause

merge_source::=
      table_path_expression
    | table_subquery

merge_statement_prefix::=
      KW_MERGE opt_into maybe_dashed_path_expression opt_as_alias KW_USING merge_source KW_ON expression

merge_statement::=
      merge_statement_prefix merge_when_clause_list

call_statement_with_args_prefix::=
      KW_CALL path_expression '(' tvf_argument
    | call_statement_with_args_prefix ',' tvf_argument

call_statement::=
      call_statement_with_args_prefix ')'
    | KW_CALL path_expression '(' ')'

opt_function_parameters::=
      function_parameters
    | /*%empty*/

opt_if_exists::=
      KW_IF KW_EXISTS
    | /*%empty*/

opt_access::=
      KW_ACCESS
    | /*%empty*/

drop_all_row_access_policies_statement::=
      KW_DROP KW_ALL KW_ROW opt_access KW_POLICIES KW_ON path_expression

on_path_expression::=
      KW_ON path_expression

opt_on_path_expression::=
      KW_ON path_expression
    | /*%empty*/

opt_drop_mode::=
      KW_RESTRICT
    | KW_CASCADE
    | /*%empty*/

drop_statement::=
      KW_DROP KW_PRIVILEGE KW_RESTRICTION opt_if_exists KW_ON privilege_list KW_ON identifier path_expression
    | KW_DROP KW_ROW KW_ACCESS KW_POLICY opt_if_exists identifier on_path_expression
    | KW_DROP index_type KW_INDEX opt_if_exists path_expression opt_on_path_expression
    | KW_DROP table_or_table_function opt_if_exists maybe_dashed_path_expression opt_function_parameters
    | KW_DROP KW_SNAPSHOT KW_TABLE opt_if_exists maybe_dashed_path_expression
    | KW_DROP generic_entity_type opt_if_exists path_expression
    | KW_DROP schema_object_kind opt_if_exists path_expression opt_function_parameters opt_drop_mode

index_type::=
      KW_SEARCH
    | KW_VECTOR

opt_index_type::=
      index_type
    | /*%empty*/

unterminated_non_empty_statement_list::=
      unterminated_statement
    | unterminated_non_empty_statement_list ';' unterminated_statement

unterminated_non_empty_top_level_statement_list::=
      unterminated_statement
    | unterminated_non_empty_top_level_statement_list ';' unterminated_statement

opt_execute_into_clause::=
      KW_INTO identifier_list
    | /*%empty*/

execute_using_argument::=
      expression KW_AS identifier
    | expression

execute_using_argument_list::=
      execute_using_argument
    | execute_using_argument_list ',' execute_using_argument

opt_execute_using_clause::=
      KW_USING execute_using_argument_list
    | /*%empty*/

execute_immediate::=
      KW_EXECUTE KW_IMMEDIATE expression opt_execute_into_clause opt_execute_using_clause

script::=
      unterminated_non_empty_top_level_statement_list
    | unterminated_non_empty_top_level_statement_list ';'
    | /*%empty*/

statement_list::=
      unterminated_non_empty_statement_list ';'
    | /*%empty*/

opt_else::=
      KW_ELSE statement_list
    | /*%empty*/

elseif_clauses::=
      KW_ELSEIF expression KW_THEN statement_list
    | elseif_clauses KW_ELSEIF expression KW_THEN statement_list

opt_elseif_clauses::=
      elseif_clauses
    | /*%empty*/

if_statement_unclosed::=
      KW_IF expression KW_THEN statement_list opt_elseif_clauses opt_else

if_statement::=
      if_statement_unclosed KW_END KW_IF

when_then_clauses::=
      KW_WHEN expression KW_THEN statement_list
    | when_then_clauses KW_WHEN expression KW_THEN statement_list

opt_expression::=
      expression
    | /*%empty*/

case_statement::=
      KW_CASE opt_expression when_then_clauses opt_else KW_END KW_CASE

begin_end_block::=
      KW_BEGIN statement_list opt_exception_handler KW_END

opt_exception_handler::=
      KW_EXCEPTION KW_WHEN KW_ERROR KW_THEN statement_list
    | /*%empty*/

opt_default_expression::=
      KW_DEFAULT expression
    | /*%empty*/

identifier_list::=
      identifier
    | identifier_list ',' identifier

variable_declaration::=
      KW_DECLARE identifier_list type opt_default_expression
    | KW_DECLARE identifier_list KW_DEFAULT expression

loop_statement::=
      KW_LOOP statement_list KW_END KW_LOOP

while_statement::=
      KW_WHILE expression KW_DO statement_list KW_END KW_WHILE

until_clause::=
      KW_UNTIL expression

repeat_statement::=
      KW_REPEAT statement_list until_clause KW_END KW_REPEAT

for_in_statement::=
      KW_FOR identifier KW_IN parenthesized_query KW_DO statement_list KW_END KW_FOR

break_statement::=
      KW_BREAK opt_identifier
    | KW_LEAVE opt_identifier

continue_statement::=
      KW_CONTINUE opt_identifier
    | KW_ITERATE opt_identifier

return_statement::=
      KW_RETURN

raise_statement::=
      KW_RAISE
    | KW_RAISE KW_USING KW_MESSAGE '=' expression

next_statement_kind::=
      next_statement_kind_without_hint
    | hint next_statement_kind_without_hint

next_statement_kind_parenthesized_select::=
      '(' next_statement_kind_parenthesized_select
    | KW_SELECT
    | KW_WITH
    | KW_FROM

next_statement_kind_table::=
      KW_TABLE

next_statement_kind_create_table_opt_as_or_semicolon::=
      KW_AS
    | ';'
    | /*%empty*/

next_statement_kind_create_modifiers::=
      opt_or_replace opt_create_scope

next_statement_kind_without_hint::=
      KW_EXPLAIN
    | next_statement_kind_parenthesized_select
    | KW_DEFINE KW_TABLE
    | KW_DEFINE_FOR_MACROS KW_MACRO
    | KW_EXECUTE KW_IMMEDIATE
    | KW_EXPORT KW_DATA
    | KW_EXPORT KW_MODEL
    | KW_EXPORT table_or_table_function KW_METADATA
    | KW_INSERT
    | KW_UPDATE
    | KW_DELETE
    | KW_MERGE
    | KW_CLONE KW_DATA
    | KW_LOAD KW_DATA
    | describe_keyword
    | KW_SHOW
    | KW_DROP KW_PRIVILEGE
    | KW_DROP KW_ALL KW_ROW opt_access KW_POLICIES
    | KW_DROP KW_ROW KW_ACCESS KW_POLICY
    | KW_DROP KW_SEARCH KW_INDEX
    | KW_DROP KW_VECTOR KW_INDEX
    | KW_DROP table_or_table_function
    | KW_DROP KW_SNAPSHOT KW_TABLE
    | KW_DROP generic_entity_type
    | KW_DROP schema_object_kind
    | KW_GRANT
    | KW_GRAPH
    | KW_REVOKE
    | KW_RENAME
    | KW_START
    | KW_BEGIN
    | KW_SET KW_TRANSACTION identifier
    | KW_SET identifier '='
    | KW_SET named_parameter_expression '='
    | KW_SET system_variable_expression '='
    | KW_SET '('
    | KW_COMMIT
    | KW_ROLLBACK
    | KW_START KW_BATCH
    | KW_RUN KW_BATCH
    | KW_ABORT KW_BATCH
    | KW_ALTER KW_APPROX KW_VIEW
    | KW_ALTER KW_CONNECTION
    | KW_ALTER KW_DATABASE
    | KW_ALTER KW_SCHEMA
    | KW_ALTER KW_EXTERNAL KW_SCHEMA
    | KW_ALTER KW_TABLE
    | KW_ALTER KW_PRIVILEGE
    | KW_ALTER KW_ROW
    | KW_ALTER KW_ALL KW_ROW KW_ACCESS KW_POLICIES
    | KW_ALTER KW_VIEW
    | KW_ALTER KW_MATERIALIZED KW_VIEW
    | KW_ALTER generic_entity_type
    | KW_ALTER KW_MODEL
    | KW_CREATE KW_DATABASE
    | KW_CREATE next_statement_kind_create_modifiers KW_CONNECTION
    | KW_CREATE next_statement_kind_create_modifiers opt_aggregate KW_CONSTANT
    | KW_CREATE next_statement_kind_create_modifiers opt_aggregate KW_FUNCTION
    | KW_CREATE next_statement_kind_create_modifiers KW_PROCEDURE
    | KW_CREATE opt_or_replace opt_unique opt_spanner_null_filtered opt_index_type KW_INDEX
    | KW_CREATE opt_or_replace KW_SCHEMA
    | KW_CREATE opt_or_replace generic_entity_type
    | KW_CREATE next_statement_kind_create_modifiers next_statement_kind_table opt_if_not_exists maybe_dashed_path_expression opt_table_element_list opt_like_path_expression opt_clone_table opt_copy_table opt_default_collate_clause opt_partition_by_clause_no_hint opt_cluster_by_clause_no_hint opt_with_connection_clause opt_options_list next_statement_kind_create_table_opt_as_or_semicolon
    | KW_CREATE next_statement_kind_create_modifiers KW_MODEL
    | KW_CREATE next_statement_kind_create_modifiers KW_TABLE KW_FUNCTION
    | KW_CREATE next_statement_kind_create_modifiers KW_EXTERNAL KW_TABLE
    | KW_CREATE next_statement_kind_create_modifiers KW_EXTERNAL KW_SCHEMA
    | KW_CREATE opt_or_replace KW_PRIVILEGE
    | KW_CREATE opt_or_replace KW_ROW opt_access KW_POLICY
    | KW_CREATE next_statement_kind_create_modifiers opt_recursive KW_VIEW
    | KW_CREATE opt_or_replace KW_APPROX opt_recursive KW_VIEW
    | KW_CREATE opt_or_replace KW_MATERIALIZED opt_recursive KW_VIEW
    | KW_CREATE opt_or_replace KW_SNAPSHOT KW_SCHEMA
    | KW_CREATE opt_or_replace KW_SNAPSHOT KW_TABLE
    | KW_CALL
    | KW_RETURN
    | KW_IMPORT
    | KW_MODULE
    | KW_ANALYZE
    | KW_ASSERT
    | KW_TRUNCATE
    | KW_IF
    | KW_WHILE
    | KW_LOOP
    | KW_DECLARE
    | KW_BREAK
    | KW_LEAVE
    | KW_CONTINUE
    | KW_ITERATE
    | KW_RAISE
    | KW_FOR
    | KW_REPEAT
    | label ':' KW_BEGIN
    | label ':' KW_LOOP
    | label ':' KW_WHILE
    | label ':' KW_FOR
    | label ':' KW_REPEAT
    | KW_UNDROP schema_object_kind

spanner_primary_key::=
      KW_PRIMARY KW_KEY primary_key_element_list

spanner_index_interleave_clause::=
      ',' KW_INTERLEAVE KW_IN maybe_dashed_path_expression

opt_spanner_interleave_in_parent_clause::=
      ',' KW_INTERLEAVE KW_IN KW_PARENT maybe_dashed_path_expression opt_foreign_key_on_delete
    | /*%empty*/

opt_spanner_table_options::=
      spanner_primary_key opt_spanner_interleave_in_parent_clause
    | /*%empty*/

opt_spanner_null_filtered::=
      KW_NULL_FILTERED
    | /*%empty*/

spanner_generated_or_default::=
      KW_AS '(' expression ')' KW_STORED
    | default_column_info

opt_spanner_generated_or_default::=
      spanner_generated_or_default
    | /*%empty*/

opt_spanner_not_null_attribute::=
      not_null_column_attribute
    | /*%empty*/

spanner_alter_column_action::=
      KW_ALTER KW_COLUMN opt_if_exists identifier column_schema_inner opt_spanner_not_null_attribute opt_spanner_generated_or_default opt_options_list

spanner_set_on_delete_action::=
      KW_SET KW_ON KW_DELETE foreign_key_action

//Tokens

KW_SHIFT_LEFT ::= "<<"
KW_LESS_EQUALS ::= "<="
KW_NOT_EQUALS_SQL_STYLE ::= "<>"
KW_NOT_EQUALS_C_STYLE ::= "!="
KW_GREATER_EQUALS ::= ">="
KW_SHIFT_RIGHT ::= ">>"
KW_CONCAT_OP ::= "||"
KW_PIPE ::= "|>"
KW_SUB_ASSIGN ::= "-="
KW_LAMBDA_ARROW ::= "->"
KW_NAMED_ARGUMENT_ASSIGNMENT ::= "=>"
KW_DOUBLE_AT ::= "@@"
KW_ADD_ASSIGN ::= "+="

KW_ABORT ::= "ABORT"
KW_ACCESS ::= "ACCESS"
KW_ACTION ::= "ACTION"
KW_ADD ::= "ADD"
KW_AGGREGATE ::= "AGGREGATE"
KW_ALL ::= "ALL"
KW_ALTER ::= "ALTER"
KW_ALWAYS ::= "ALWAYS"
KW_ANALYZE ::= "ANALYZE"
KW_AND ::= "AND"
KW_ANY ::= "ANY"
KW_APPROX ::= "APPROX"
KW_ARE ::= "ARE"
KW_ARRAY ::= "ARRAY"
KW_ASC ::= "ASC"
KW_AS ::= "AS"
KW_ASSERT ::= "ASSERT"
KW_ASSERT_ROWS_MODIFIED ::= "ASSERT_ROWS_MODIFIED"
KW_AT ::= "AT"
KW_BATCH ::= "BATCH"
KW_BEGIN ::= "BEGIN"
KW_BETWEEN ::= "BETWEEN"
KW_BIGDECIMAL ::= "BIGDECIMAL"
KW_BIGNUMERIC ::= "BIGNUMERIC"
KW_BREAK ::= "BREAK"
KW_BY ::= "BY"
KW_CALL ::= "CALL"
KW_CASCADE ::= "CASCADE"
KW_CASE ::= "CASE"
KW_CAST ::= "CAST"
KW_CHECK ::= "CHECK"
KW_CLAMPED ::= "CLAMPED"
KW_CLONE ::= "CLONE"
KW_CLUSTER ::= "CLUSTER"
KW_COLLATE ::= "COLLATE"
KW_COLUMN ::= "COLUMN"
KW_COLUMNS ::= "COLUMNS"
KW_COMMIT ::= "COMMIT"
KW_CONNECTION ::= "CONNECTION"
KW_CONSTANT ::= "CONSTANT"
KW_CONSTRAINT ::= "CONSTRAINT"
KW_CONTINUE ::= "CONTINUE"
KW_COPY ::= "COPY"
KW_CORRESPONDING ::= "CORRESPONDING"
KW_CREATE ::= "CREATE"
KW_CROSS ::= "CROSS"
KW_CUBE ::= "CUBE"
KW_CURRENT ::= "CURRENT"
KW_CYCLE ::= "CYCLE"
KW_DATABASE ::= "DATABASE"
KW_DATA ::= "DATA"
KW_DATE ::= "DATE"
KW_DATETIME ::= "DATETIME"
KW_DECIMAL ::= "DECIMAL"
KW_DECLARE ::= "DECLARE"
KW_DEFAULT ::= "DEFAULT"
KW_DEFINE ::= "DEFINE"
KW_DEFINER ::= "DEFINER"
KW_DELETE ::= "DELETE"
KW_DELETION ::= "DELETION"
KW_DEPTH ::= "DEPTH"
KW_DESC ::= "DESC"
KW_DESCRIBE ::= "DESCRIBE"
KW_DESCRIPTOR ::= "DESCRIPTOR"
KW_DETERMINISTIC ::= "DETERMINISTIC"
KW_DISTINCT ::= "DISTINCT"
KW_DO ::= "DO"
KW_DROP ::= "DROP"
KW_ELSEIF ::= "ELSEIF"
KW_ELSE ::= "ELSE"
KW_END ::= "END"
KW_ENFORCED ::= "ENFORCED"
KW_ENUM ::= "ENUM"
KW_ERROR ::= "ERROR"
KW_EXCEPTION ::= "EXCEPTION"
KW_EXCEPT ::= "EXCEPT"
KW_EXCLUDE ::= "EXCLUDE"
KW_EXECUTE ::= "EXECUTE"
KW_EXISTS ::= "EXISTS"
KW_EXPLAIN ::= "EXPLAIN"
KW_EXPORT ::= "EXPORT"
KW_EXTEND ::= "EXTEND"
KW_EXTERNAL ::= "EXTERNAL"
KW_EXTRACT ::= "EXTRACT"
KW_FALSE ::= "FALSE"
KW_FILES ::= "FILES"
KW_FILL ::= "FILL"
KW_FILTER ::= "FILTER"
KW_FIRST ::= "FIRST"
KW_FOLLOWING ::= "FOLLOWING"
KW_FOREIGN ::= "FOREIGN"
KW_FOR ::= "FOR"
KW_FORMAT ::= "FORMAT"
KW_FROM ::= "FROM"
KW_FUNCTION ::= "FUNCTION"
KW_FULL ::= "FULL"
KW_GENERATED ::= "GENERATED"
KW_GRANT ::= "GRANT"
KW_GRAPH ::= "GRAPH"
KW_GROUPING ::= "GROUPING"
KW_GROUP ::= "GROUP"
KW_GROUP_ROWS ::= "GROUP_ROWS"
KW_HASH ::= "HASH"
KW_HAVING ::= "HAVING"
KW_HIDDEN ::= "HIDDEN"
KW_IDENTITY ::= "IDENTITY"
KW_IF ::= "IF"
KW_IGNORE ::= "IGNORE"
KW_IMMEDIATE ::= "IMMEDIATE"
KW_IMMUTABLE ::= "IMMUTABLE"
KW_IMPORT ::= "IMPORT"
KW_INCLUDE ::= "INCLUDE"
KW_INCREMENT ::= "INCREMENT"
KW_INDEX ::= "INDEX"
KW_IN ::= "IN"
KW_INNER ::= "INNER"
KW_INOUT ::= "INOUT"
KW_INPUT ::= "INPUT"
KW_INSERT ::= "INSERT"
KW_INTERLEAVE ::= "INTERLEAVE"
KW_INTERSECT ::= "INTERSECT"
KW_INTERVAL ::= "INTERVAL"
KW_INTO ::= "INTO"
KW_INVOKER ::= "INVOKER"
KW_IS ::= "IS"
KW_ISOLATION ::= "ISOLATION"
KW_ITERATE ::= "ITERATE"
KW_JOIN ::= "JOIN"
KW_JSON ::= "JSON"
KW_KEY ::= "KEY"
KW_LANGUAGE ::= "LANGUAGE"
KW_LAST ::= "LAST"
KW_LEAVE ::= "LEAVE"
KW_LEFT ::= "LEFT"
KW_LEVEL ::= "LEVEL"
KW_LIKE ::= "LIKE"
KW_LIMIT ::= "LIMIT"
KW_LOAD ::= "LOAD"
KW_LOOKUP ::= "LOOKUP"
KW_LOOP ::= "LOOP"
KW_MACRO ::= "MACRO"
KW_MAP ::= "MAP"
KW_MATCHED ::= "MATCHED"
KW_MATCH ::= "MATCH"
KW_MATERIALIZED ::= "MATERIALIZED"
KW_MAX ::= "MAX"
KW_MAXVALUE ::= "MAXVALUE"
KW_MEASURES ::= "MEASURES"
KW_MERGE ::= "MERGE"
KW_MESSAGE ::= "MESSAGE"
KW_METADATA ::= "METADATA"
KW_MIN ::= "MIN"
KW_MINVALUE ::= "MINVALUE"
KW_MODEL ::= "MODEL"
KW_MODULE ::= "MODULE"
KW_NATURAL ::= "NATURAL"
KW_NEW ::= "NEW"
KW_NO ::= "NO"
KW_NOT ::= "NOT"
KW_NOT_SPECIAL ::= "NOT_SPECIAL"
KW_NULL_FILTERED ::= "NULL_FILTERED"
KW_NULL ::= "NULL"
KW_NULLS ::= "NULLS"
KW_NUMERIC ::= "NUMERIC"
KW_OFFSET ::= "OFFSET"
KW_OF ::= "OF"
KW_ON ::= "ON"
KW_ONLY ::= "ONLY"
KW_OPTIONS ::= "OPTIONS"
KW_ORDER ::= "ORDER"
KW_OR ::= "OR"
KW_OUTER ::= "OUTER"
KW_OUT ::= "OUT"
KW_OUTPUT ::= "OUTPUT"
KW_OVER ::= "OVER"
KW_OVERWRITE ::= "OVERWRITE"
KW_PARENT ::= "PARENT"
KW_PARTITION ::= "PARTITION"
KW_PARTITIONS ::= "PARTITIONS"
KW_PATTERN ::= "PATTERN"
KW_PERCENT ::= "PERCENT"
KW_PIVOT ::= "PIVOT"
KW_POLICIES ::= "POLICIES"
KW_POLICY ::= "POLICY"
KW_PRECEDING ::= "PRECEDING"
KW_PRIMARY ::= "PRIMARY"
KW_PRIVATE ::= "PRIVATE"
KW_PRIVILEGE ::= "PRIVILEGE"
KW_PRIVILEGES ::= "PRIVILEGES"
KW_PROCEDURE ::= "PROCEDURE"
KW_PROJECT ::= "PROJECT"
KW_PROTO ::= "PROTO"
KW_PUBLIC ::= "PUBLIC"
KW_RAISE ::= "RAISE"
KW_RANGE ::= "RANGE"
KW_READ ::= "READ"
KW_RECURSIVE ::= "RECURSIVE"
KW_REFERENCES ::= "REFERENCES"
KW_REMOTE ::= "REMOTE"
KW_REMOVE ::= "REMOVE"
KW_RENAME ::= "RENAME"
KW_REPEATABLE ::= "REPEATABLE"
KW_REPEAT ::= "REPEAT"
KW_REPLACE_FIELDS ::= "REPLACE_FIELDS"
KW_REPLACE ::= "REPLACE"
KW_REPLICA ::= "REPLICA"
KW_REPORT ::= "REPORT"
KW_RESPECT ::= "RESPECT"
KW_RESTRICTION ::= "RESTRICTION"
KW_RESTRICT ::= "RESTRICT"
KW_RETURN ::= "RETURN"
KW_RETURNS ::= "RETURNS"
KW_REVOKE ::= "REVOKE"
KW_RIGHT ::= "RIGHT"
KW_ROLLBACK ::= "ROLLBACK"
KW_ROLLUP ::= "ROLLUP"
KW_ROW ::= "ROW"
KW_ROWS ::= "ROWS"
KW_RUN ::= "RUN"
KW_SAFE_CAST ::= "SAFE_CAST"
KW_SCHEMA ::= "SCHEMA"
KW_SEARCH ::= "SEARCH"
KW_SECURITY ::= "SECURITY"
KW_SELECT ::= "SELECT"
KW_SEQUENCE ::= "SEQUENCE"
KW_SET ::= "SET"
KW_SETS ::= "SETS"
KW_SHOW ::= "SHOW"
KW_SIMPLE ::= "SIMPLE"
KW_SNAPSHOT ::= "SNAPSHOT"
KW_SOME ::= "SOME"
KW_SOURCE ::= "SOURCE"
KW_SQL ::= "SQL"
KW_STABLE ::= "STABLE"
KW_START ::= "START"
KW_STATIC_DESCRIBE ::= "STATIC_DESCRIBE"
KW_STORED ::= "STORED"
KW_STORING ::= "STORING"
KW_STRICT ::= "STRICT"
KW_STRUCT ::= "STRUCT"
KW_SYSTEM ::= "SYSTEM"
KW_SYSTEM_TIME ::= "SYSTEM_TIME"
KW_TABLE ::= "TABLE"
KW_TABLESAMPLE ::= "TABLESAMPLE"
KW_TABLES ::= "TABLES"
KW_TARGET ::= "TARGET"
KW_TEMP ::= "TEMP"
KW_TEMPORARY ::= "TEMPORARY"
KW_THEN ::= "THEN"
KW_TIME ::= "TIME"
KW_TIMESTAMP ::= "TIMESTAMP"
KW_TO ::= "TO"
KW_TRANSACTION ::= "TRANSACTION"
KW_TRANSFORM ::= "TRANSFORM"
KW_TRUE ::= "TRUE"
KW_TRUNCATE ::= "TRUNCATE"
KW_TYPE ::= "TYPE"
KW_UNBOUNDED ::= "UNBOUNDED"
KW_UNDROP ::= "UNDROP"
KW_UNION ::= "UNION"
KW_UNIQUE ::= "UNIQUE"
KW_UNKNOWN ::= "UNKNOWN"
KW_UNNEST ::= "UNNEST"
KW_UNPIVOT ::= "UNPIVOT"
KW_UNTIL ::= "UNTIL"
KW_UPDATE ::= "UPDATE"
KW_USING ::= "USING"
KW_VALUE ::= "VALUE"
KW_VALUES ::= "VALUES"
KW_VECTOR ::= "VECTOR"
KW_VIEW ::= "VIEW"
KW_VIEWS ::= "VIEWS"
KW_VOLATILE ::= "VOLATILE"
KW_WEIGHT ::= "WEIGHT"
KW_WHEN ::= "WHEN"
KW_WHERE ::= "WHERE"
KW_WHILE ::= "WHILE"
KW_WINDOW ::= "WINDOW"
KW_WITH ::= "WITH"
KW_WRITE ::= "WRITE"
KW_ZONE ::= "ZONE"

[mingodad]

I've just added zetasql grammar to https://mingodad.github.io/parsertl-playground/playground/ (select "ZetaSQL parser (be patient)(partially working)" from "Examples" then click "Parse" to see a parser tree for the content in "Input source").

I hope it can help debug/develop/experiment with zetasql grammar.

[mingodad]

I've also updated the zetasql grammar and example on https://mingodad.github.io/parsertl-playground/playground/ with the latest grammar that now has PIPE (|>) operator.