Query Grammar (EBNF)

stringVal
         ::= STRINGVAL

nonReserved
         ::= 'exception'
           | 'serial'
           | 'object'
           | 'index'
           | 'json'
           | 'geometry'
           | 'geography'
           | 'default'
           | basicNonReserved

basicNonReserved
         ::= 'instead'
           | 'view'
           | 'enabled'
           | 'disabled'
           | 'key'
           | 'textagg'
           | 'count'
           | 'count_big'
           | 'row_number'
           | 'rank'
           | 'dense_rank'
           | 'sum'
           | 'avg'
           | 'min'
           | 'max'
           | 'every'
           | 'stddev_pop'
           | 'stddev_samp'
           | 'var_samp'
           | 'var_pop'
           | 'document'
           | 'content'
           | 'trim'
           | 'empty'
           | 'ordinality'
           | 'path'
           | 'first'
           | 'last'
           | 'next'
           | 'substring'
           | 'extract'
           | 'to_chars'
           | 'to_bytes'
           | 'timestampadd'
           | 'timestampdiff'
           | 'querystring'
           | 'namespace'
           | 'result'
           | 'accesspattern'
           | 'auto_increment'
           | 'wellformed'
           | 'sql_tsi_frac_second'
           | 'sql_tsi_second'
           | 'sql_tsi_minute'
           | 'sql_tsi_hour'
           | 'sql_tsi_day'
           | 'sql_tsi_week'
           | 'sql_tsi_month'
           | 'sql_tsi_quarter'
           | 'sql_tsi_year'
           | 'texttable'
           | 'arraytable'
           | 'jsontable'
           | 'selector'
           | 'skip'
           | 'width'
           | 'passing'
           | 'name'
           | 'encoding'
           | 'columns'
           | 'delimiter'
           | 'quote'
           | 'header'
           | 'nulls'
           | 'objecttable'
           | 'version'
           | 'including'
           | 'excluding'
           | 'xmldeclaration'
           | 'variadic'
           | 'raise'
           | 'chain'
           | 'jsonarray_agg'
           | 'jsonobject'
           | 'preserve'
           | 'upsert'
           | 'after'
           | 'type'
           | 'translator'
           | 'jaas'
           | 'condition'
           | 'mask'
           | 'access'
           | 'control'
           | 'none'
           | 'data'
           | 'database'
           | 'privileges'
           | 'role'
           | 'schema'
           | 'use'
           | 'repository'
           | 'rename'
           | 'domain'
           | 'usage'
           | 'position'
           | 'current'
           | 'unbounded'
           | 'preceding'
           | 'following'
           | 'listagg'
           | 'explain'
           | 'analyze'
           | 'text'
           | 'format'
           | 'yaml'
           | 'epoch'
           | 'quarter'
           | 'policy'

unqualifiedId
         ::= ID
           | nonReserved

id       ::= ID
           | nonReserved

command  ::= ( createProcedure | userCommand | callableStatement | explainCommand ) ';'? EOF

createTrigger
         ::= 'create' 'trigger' id? 'on' id ( 'instead' 'of' | 'after' ) ( 'insert' | 'update' | 'delete' ) 'as' forEachRowTriggerAction

alter    ::= 'alter' ( 'view' id 'as' queryExpression | 'procedure' id 'as' statement | 'trigger' id? 'on' id ( 'instead' 'of' | 'after' ) ( 'insert' | 'update' | 'delete' ) ( 'as' forEachRowTriggerAction | 'enabled' | 'disabled' ) )

forEachRowTriggerAction
         ::= 'for' 'each' 'row' ( 'begin' 'atomic'? statement* 'end' | statement )

explainCommand
         ::= 'explain' ( '(' explainOption ( ',' explainOption )* ')' )? userCommand

explainOption
         ::= 'analyze' ( 'true' | 'false' )?
           | 'format' ( 'xml' | 'text' | 'yaml' )?

userCommand
         ::= queryExpression
           | storedProcedure
           | insert
           | update
           | delete
           | dropTable
           | createTempTable
           | createForeignTempTable
           | alter
           | createTrigger
           | compoundStatement

dropTable
         ::= 'drop' 'table' id

createTempTable
         ::= 'create' 'local'? 'temporary' 'table' unqualifiedId '(' tableElement ( ',' tableElement )* ( ',' 'primary' 'key' columnList )? ')' ( 'on' 'commit' 'preserve' 'rows' )?

tableElement
         ::= id ( parseBasicDataType | 'serial' ) ( 'not' 'null' )?

errorStatement
         ::= 'error' expression

raiseStatement
         ::= 'raise' 'sqlwarning'? exceptionReference

exceptionReference
         ::= id
           | exception

exception
         ::= 'sqlexception' commonValueExpression ( 'sqlstate' commonValueExpression ( ',' commonValueExpression )? )? ( 'chain' exceptionReference )?

statement
         ::= ( id ':' )? ( loopStatement | whileStatement | compoundStatement )
           | ifStatement
           | delimitedStatement

delimitedStatement
         ::= ( assignStatement | sqlStatement | errorStatement | raiseStatement | declareStatement | branchingStatement | returnStatement ) ';'

compoundStatement
         ::= 'begin' ( 'not'? 'atomic' )? statement* ( 'exception' id statement* )? 'end'

branchingStatement
         ::= ( 'break' | 'continue' ) id?
           | 'leave' id

returnStatement
         ::= 'return' expression?

whileStatement
         ::= 'while' '(' criteria ')' statement

loopStatement
         ::= 'loop' 'on' '(' queryExpression ')' 'as' id statement

ifStatement
         ::= 'if' '(' criteria ')' statement ( 'else' statement )?

declareStatement
         ::= 'declare' ( parseDataType | 'exception' ) id ( '=' assignStatementOperand )?

assignStatement
         ::= id '=' ( assignStatementOperand | storedProcedure ( ( 'with' | 'without' ) 'return' )? )

assignStatementOperand
         ::= insert
           | update
           | delete
           | expression
           | queryExpression
           | exception

sqlStatement
         ::= ( userCommand | dynamicCommand ) ( ( 'with' | 'without' ) 'return' )?

createProcedure
         ::= 'create' 'virtual'? 'procedure' statement

procedureBodyCommand
         ::= ( 'create' 'virtual'? 'procedure' )? statement EOF

dynamicCommand
         ::= ( 'execute' | 'exec' ) ( 'string' | 'immediate' )? expression ( 'as' createElementsWithTypes ( 'into' id )? )? ( 'using' setClauseList )? ( 'update' ( intVal | '*' ) )?

setClauseList
         ::= id '=' expression ( ',' id '=' expression )*

createElementsWithTypes
         ::= id parseBasicDataType ( ',' id parseBasicDataType )*

callableStatement
         ::= '{' ( '?' '=' )? 'call' id ( '(' ( executeNamedParams | expressionList )? ')' )? '}' option?

storedProcedure
         ::= ( 'exec' | 'execute' | 'call' ) id '(' ( executeNamedParams | expressionList )? ')' option?

executeNamedParams
         ::= id '=' '>'? expression ( ',' id '=' '>'? expression )*

insert   ::= ( 'insert' | 'merge' | 'upsert' ) 'into' id columnList? queryExpression option?

expressionList
         ::= expression ( ',' expression )*

update   ::= 'update' id ( 'as'? id )? 'set' setClauseList where? option?

delete   ::= 'delete' 'from' id ( 'as'? id )? where? option?

queryExpression
         ::= ( 'with' withListElement ( ',' withListElement )* )? queryExpressionBody

withListElement
         ::= id columnList? 'as' '(' queryExpression ')'

queryExpressionBody
         ::= queryTerm ( ( 'union' | 'except' ) ( 'all' | 'distinct' )? queryTerm )* orderby? limit? option?

queryTerm
         ::= queryPrimary ( 'intersect' ( 'all' | 'distinct' )? queryPrimary )*

queryPrimary
         ::= query
           | ( 'values' '(' expressionList ( ')' ',' '(' expressionList )* | '(' queryExpressionBody ) ')'
           | 'table' id

query    ::= select into? ( from where? groupBy? having? )?

into     ::= 'into' id

select   ::= 'select' ( 'all' | 'distinct' )? ( '*' | selectSymbol ( ',' selectSymbol )* )

selectSymbol
         ::= selectExpression
           | allInGroupSymbol

selectExpression
         ::= expression ( 'as'? id )?

derivedColumn
         ::= expression ( 'as' id )?

allInGroupSymbol
         ::= ALL_IN_GROUP

orderedAgg
         ::= ( 'xmlagg' | 'array_agg' | 'jsonarray_agg' ) '(' expression orderby? ')'

textAgg  ::= 'textagg' '(' 'for'? derivedColumn ( ',' derivedColumn )* ( 'delimiter' charVal )? ( 'quote' charVal | 'no' 'quote' )? 'header'? ( 'encoding' id )? orderby? ')'

aggregateSymbol
         ::= ( ( 'count' | 'count_big' ) '(' '*' | ( 'count' | 'count_big' | 'sum'
                  | 'avg' | 'min' | 'max' | 'every' | 'stddev_pop' | 'stddev_samp' | 'var_samp' | 'var_pop'
                  | 'some' | 'any' ) '(' ( 'distinct' | 'all' )? expression ) ')'

analyticAggregateSymbol
         ::= ( 'row_number' | 'rank' | 'dense_rank' | 'percent_rank' | 'cume_dist'
                  ) '(' ')'

filterClause
         ::= 'filter' '(' 'where' criteria ')'

from     ::= 'from' tableReference ( ',' tableReference )*

tableReference
         ::= ESCAPEDJOIN joinedTable '}'
           | joinedTable

joinedTable
         ::= tablePrimary ( crossJoin | qualifiedJoin )*

crossJoin
         ::= ( 'cross' | 'union' ) 'join' tablePrimary

qualifiedJoin
         ::= ( ( 'right' | 'left' | 'full' ) 'outer'? | 'inner' )? 'join' tableReference 'on' criteria

tablePrimary
         ::= ( textTable | arrayTable | jsonTable | xmlTable | objectTable | unaryFromClause | subqueryFromClause | '(' joinedTable ')' ) ( 'makedep' makedepOptions | 'makenotdep' )? ( 'makeind' makedepOptions )?

makedepOptions
         ::= ( '(' ( 'max' ':' intVal )? ( 'no'? 'join' )? ')' )?

xmlSerialize
         ::= 'xmlserialize' '(' ( 'document' | 'content' )? expression ( 'as' ( 'string' | 'varchar' | 'clob' | 'varbinary' | 'blob' ) )? ( 'encoding' id )? ( 'version' stringVal )? ( ( 'including' | 'excluding' ) 'xmldeclaration' )? ')'

arrayTable
         ::= 'arraytable' '(' ( 'row' | 'rows' )? valueExpressionPrimary 'columns' createElementsWithTypes ')' 'as'? id

jsonTable
         ::= 'jsontable' '(' valueExpressionPrimary ',' stringVal ( ',' ( 'true' | 'false' ) )? 'columns' jsonColumn ( ',' jsonColumn )* ')' 'as'? id

jsonColumn
         ::= id ( 'for' 'ordinality' | parseBasicDataType ( 'path' stringVal )? )

textTable
         ::= 'texttable' '(' commonValueExpression ( 'selector' stringVal )? 'columns' textColumn ( ',' textColumn )* ( 'no' 'row' 'delimiter' | 'row' 'delimiter' charVal )? ( 'delimiter' charVal )? ( ( 'escape' | 'quote' ) charVal )? ( 'header' intVal? )? ( 'skip' intVal )? ( 'no' 'trim' )? ')' 'as'? id

textColumn
         ::= id ( 'for' 'ordinality' | ( 'header' stringVal )? parseBasicDataType ( 'width' intVal ( 'no' 'trim' )? )? ( 'selector' stringVal intVal )? )

xmlExists
         ::= 'xmlexists' '(' ( xmlNamespaces ',' )? stringVal ( 'passing' derivedColumn ( ',' derivedColumn )* )? ')'

xmlQuery ::= 'xmlquery' '(' ( xmlNamespaces ',' )? stringVal ( 'passing' derivedColumn ( ',' derivedColumn )* )? ( ( 'null' | 'empty' ) 'on' 'empty' )? ')'

objectTable
         ::= 'objecttable' '(' ( 'language' stringVal )? stringVal ( 'passing' derivedColumn ( ',' derivedColumn )* )? 'columns' objectColumn ( ',' objectColumn )* ')' 'as'? id

objectColumn
         ::= id parseBasicDataType stringVal ( 'default' expression )?

xmlTable ::= 'xmltable' '(' ( xmlNamespaces ',' )? stringVal ( 'passing' derivedColumn ( ',' derivedColumn )* )? ( 'columns' xmlColumn ( ',' xmlColumn )* )? ')' 'as'? id

xmlColumn
         ::= id ( 'for' 'ordinality' | parseBasicDataType ( 'default' expression )? ( 'path' stringVal )? )

intVal   ::= UNSIGNEDINTEGER

subqueryFromClause
         ::= ( 'table' | 'lateral' )? '(' ( queryExpression | storedProcedure ) ')' 'as'? id

unaryFromClause
         ::= id ( 'as'? id )?

where    ::= 'where' criteria

criteria ::= compoundCritOr

compoundCritOr
         ::= compoundCritAnd ( 'or' compoundCritAnd )*

compoundCritAnd
         ::= notCrit ( 'and' notCrit )*

notCrit  ::= 'not'? booleanPrimary

booleanPrimary
         ::= commonValueExpression ( betweenCrit | matchCrit | regexMatchCrit | setCrit | isNullCrit | subqueryCompareCriteria | compareCrit | isDistinct )?
           | existsCriteria
           | xmlExists

operator ::= '='
           | '<>'
           | '!='
           | '<'
           | '<='
           | '>'
           | '>='

isDistinct
         ::= 'is' 'not'? 'distinct' 'from' commonValueExpression

compareCrit
         ::= operator commonValueExpression

subquery ::= '(' ( queryExpression | storedProcedure ) ')'

subqueryCompareCriteria
         ::= operator ( 'any' | 'some' | 'all' ) ( subquery | '(' expression ')' )

matchCrit
         ::= 'not'? ( 'like' | 'similar' 'to' ) commonValueExpression ( 'escape' charVal | '{' 'escape' charVal '}' )?

regexMatchCrit
         ::= 'not'? 'like_regex' commonValueExpression

charVal  ::= stringVal

betweenCrit
         ::= 'not'? 'between' commonValueExpression 'and' commonValueExpression

isNullCrit
         ::= 'is' 'not'? 'null'

setCrit  ::= 'not'? 'in' ( subquery | '(' commonValueExpression ( ',' commonValueExpression )* ')' )

existsCriteria
         ::= 'exists' subquery

groupBy  ::= 'group' 'by' ( 'ROLLUP' '(' expressionList ')' | expressionList )

having   ::= 'having' criteria

orderby  ::= 'order' 'by' sortSpecification ( ',' sortSpecification )*

sortSpecification
         ::= sortKey ( 'asc' | 'desc' )? ( 'nulls' ( 'first' | 'last' ) )?

sortKey  ::= expression

intParam ::= intVal
           | unsignedValueExpressionPrimary

limit    ::= 'limit' intParam ( ( ',' | 'offset' ) intParam )?
           | 'offset' intParam ( 'row' | 'rows' ) fetchLimit?
           | fetchLimit

fetchLimit
         ::= 'fetch' ( 'first' | 'next' ) intParam? ( 'row' | 'rows' ) 'only'

option   ::= 'option' ( ( 'makedep' | 'makeind' ) id makedepOptions ( ',' id makedepOptions )* | 'makenotdep' id ( ',' id )* | 'nocache' ( id ( ',' id )* )? )*

expression
         ::= criteria

commonValueExpression
         ::= plusExpression ( ( '&&' | '||' ) plusExpression )*

plusExpression
         ::= timesExpression ( plusMinus timesExpression )*

plusMinus
         ::= '+'
           | '-'

timesExpression
         ::= valueExpressionPrimary ( timesOperator valueExpressionPrimary )*

timesOperator
         ::= '*'
           | '/'

valueExpressionPrimary
         ::= nonNumericLiteral
           | plusMinus? ( unsignedNumericLiteral | unsignedValueExpressionPrimary ( '[' plusExpression ']' )* )

parameterReference
         ::= '?'
           | '$' intVal

unescapedFunction
         ::= ( ( textAgg | aggregateSymbol | orderedAgg ) filterClause? | function ) windowSpecification?
           | analyticAggregateSymbol filterClause? windowSpecification
           | 'xmlcast' '(' expression 'as' parseDataType ')'

nestedExpression
         ::= '(' ( expression ( ',' expression )* )? ','? ')'

unsignedValueExpressionPrimary
         ::= parameterReference
           | ESCAPEDFUNCTION function '}'
           | unescapedFunction
           | ID
           | nonReserved
           | subquery
           | nestedExpression
           | arrayExpression
           | searchedCaseExpression
           | caseExpression

arrayExpression
         ::= 'array' ( '[' ( expression ( ',' expression )* )? ']' | '(' queryExpression ')' )

windowSpecification
         ::= 'over' '(' ( 'partition' 'by' expressionList )? orderby? windowFrame? ')'

windowFrame
         ::= ( 'range' | 'rows' ) ( 'between' windowFrameBound 'and' )? windowFrameBound

windowFrameBound
         ::= ( 'unbounded' | intVal ) ( 'following' | 'preceding' )
           | 'current' 'row'

caseExpression
         ::= 'case' expression ( 'when' expression 'then' expression )+ ( 'else' expression )? 'end'

searchedCaseExpression
         ::= 'case' ( 'when' criteria 'then' expression )+ ( 'else' expression )? 'end'

function ::= ( ( 'convert' '(' expression ',' | 'cast' '(' expression 'as' ) parseDataType | 'substring' '(' expression ( 'from' expression ( 'for' expression )? | ',' expressionList ) | ( 'extract' '(' ( 'year' | 'month' | 'day' | 'hour' | 'minute' | 'second' | 'quarter'
                  | 'epoch' | 'dow' | 'doy' ) 'from' | 'trim' '(' ( ( ( 'leading' | 'trailing' | 'both'
                  ) expression? | expression ) 'from' )? | ( 'timestampadd' | 'timestampdiff' ) '(' intervalType ',' expression ',' ) expression | ( ( 'to_chars' | 'to_bytes' ) '(' expression ',' stringVal | 'xmlpi' '(' 'name'? id ) ( ',' expression )? | ( 'left' | 'right' | 'char' | 'user' | 'year' | 'month' | 'hour' | 'minute'
                  | 'second' | 'xmlconcat' | 'xmlcomment' | 'xmltext' | 'translate' | 'insert' ) '('
                  expressionList? | 'position' '(' commonValueExpression 'in' commonValueExpression | 'listagg' '(' expression ( ',' stringVal )? ')' 'within' 'group' '(' orderby ) ')'
           | queryString
           | xmlParse
           | xmlElement
           | xmlForest
           | jsonObject
           | xmlSerialize
           | xmlQuery
           | id '(' ( 'all' | 'distinct' )? expressionList? orderby? ')' filterClause?
           | 'current_date' ( '(' ')' )?
           | ( 'current_timestamp' | 'current_time' ) ( '(' intVal ')' )?
           | 'session_user'

xmlParse ::= 'xmlparse' '(' ( 'document' | 'content' ) expression 'wellformed'? ')'

queryString
         ::= 'querystring' '(' expression ( ',' derivedColumn )* ')'

xmlElement
         ::= 'xmlelement' '(' 'name'? id ( ',' xmlNamespaces )? ( ',' xmlAttributes )? ( ',' expression )* ')'

xmlAttributes
         ::= 'xmlattributes' '(' derivedColumn ( ',' derivedColumn )* ')'

jsonObject
         ::= 'jsonobject' '(' derivedColumnList ')'

derivedColumnList
         ::= derivedColumn ( ',' derivedColumn )*

xmlForest
         ::= 'xmlforest' '(' ( xmlNamespaces ',' )? derivedColumnList ')'

xmlNamespaces
         ::= 'xmlnamespaces' '(' namespaceItem ( ',' namespaceItem )* ')'

namespaceItem
         ::= stringVal 'as' id
           | 'no' 'default'
           | 'default' stringVal

parseDataTypePrimary
         ::= ( 'string' | 'varchar' | 'char' | 'biginteger' | 'timestamp' | 'object'
                  | 'blob' | 'clob' | 'varbinary' ) ( '(' intVal ')' )?
           | 'boolean'
           | 'byte'
           | 'tinyint'
           | 'short'
           | 'smallint'
           | 'integer'
           | 'long'
           | 'bigint'
           | 'float'
           | 'real'
           | 'double'
           | ( 'bigdecimal' | 'decimal' ) ( '(' intVal ( ',' intVal )? ')' )?
           | 'date'
           | 'time'
           | 'json'
           | 'geometry'
           | 'geography'
           | 'xml'

parseBasicDataType
         ::= parseDataTypePrimary ( '[' ']' )*

parseDataType
         ::= parseBasicDataType
           | ( ID | basicNonReserved ) ( '[' ']' )*

intervalType
         ::= 'sql_tsi_frac_second'
           | 'sql_tsi_second'
           | 'sql_tsi_minute'
           | 'sql_tsi_hour'
           | 'sql_tsi_day'
           | 'sql_tsi_week'
           | 'sql_tsi_month'
           | 'sql_tsi_quarter'
           | 'sql_tsi_year'

nonNumericLiteral
         ::= ( 'date' | 'time' | 'timestamp' )? stringVal
           | BINARYSTRINGVAL
           | 'false'
           | 'true'
           | 'unknown'
           | 'null'
           | ESCAPEDTYPE stringVal '}'

unsignedNumericLiteral
         ::= UNSIGNEDINTEGER
           | FLOATVAL
           | DECIMALVAL

parseMetadata
         ::= ddlStmt? ( ';' ddlStmt? )* EOF

ddlStmt  ::= createDDLProcedure* ( createTable ( createTable | createDDLProcedure )? | createNameSpace | alterStatement | createTrigger | createDomain | createServer | createRole | dropRole | grant | revokeGrant | createPolicy | dropPolicy | dropServer | dropTableView | importSchema | importDatabase | createDatabase | useDatabase | dropSchema | useSchema | createSchema | createDDLProcedure | createDataWrapper | dropDataWrapper | dropProcedure )

createNameSpace
         ::= 'set' 'namespace' stringVal 'as' id

createDatabase
         ::= 'create' 'database' id ( 'version' stringVal )? optionsClause?

useDatabase
         ::= 'use' 'database' id ( 'version' stringVal )?

createSchema
         ::= 'create' ( 'virtual' | 'foreign' )? 'schema' id ( 'server' identifierList )? optionsClause?

dropSchema
         ::= 'drop' ( 'virtual' | 'foreign' )? 'schema' id

useSchema
         ::= 'set' 'schema' id

createDomain
         ::= 'create' 'domain' ( ID | basicNonReserved ) 'as'? parseDataType ( 'not' 'null' )?

createDataWrapper
         ::= 'create' 'foreign' ( 'data' 'wrapper' | 'translator' ) unqualifiedId ( 'type' id optionsClause? )?

dropDataWrapper
         ::= 'drop' 'foreign' ( 'data' 'wrapper' | 'translator' ) id

createRole
         ::= 'create' 'role' unqualifiedId ( 'with' readWith )?

readWith ::= 'any' 'authenticated'
           | ( 'jaas' | 'foreign' ) 'role' identifierList

dropRole ::= 'drop' 'role' id

createPolicy
         ::= 'create' 'policy' id 'on' ( id ( 'for' ( 'all' | ( 'select' | 'insert' | 'update' | 'delete' ) ( ',' ( 'select'
                  | 'insert' | 'update' | 'delete' ) )* ) )? | 'procedure' id ( 'for' 'all' )? ) 'to' id 'using' '(' criteria ')'

dropPolicy
         ::= 'drop' 'policy' id 'on' 'procedure'? id 'to' id

grant    ::= 'grant' ( ( readGrantTypes ( ',' readGrantTypes )* )? 'on' ( ( 'table' | 'procedure' ) id ( 'condition' ( 'not'? 'constraint' )? stringVal )? | ( 'function' | 'schema' ) id | 'column' id ( 'mask' ( 'order' intVal )? stringVal )? ( 'condition' ( criteria | stringVal ) )? ) | 'all' 'privileges' | 'temporary' 'table' | 'usage' 'on' 'language' id ) 'to' id

revokeGrant
         ::= 'REVOKE' ( ( readGrantTypes ( ',' readGrantTypes )* )? 'on' ( ( 'table' | 'procedure' ) id 'condition'? | ( 'function' | 'schema' ) id | 'column' id 'mask'? ) | 'all' 'privileges' | 'temporary' 'table' | 'usage' 'on' 'language' id ) 'from' id

createServer
         ::= 'create' 'server' unqualifiedId ( 'type' stringVal )? ( 'version' stringVal )? 'foreign' ( 'data' 'wrapper' | 'translator' ) unqualifiedId optionsClause?

dropServer
         ::= 'drop' 'server' id

createDDLProcedure
         ::= 'create' ( 'virtual' | 'foreign' )? ( 'procedure' | 'function' ) unqualifiedId '(' ( procedureParameter ( ',' procedureParameter )* )? ')' ( 'returns' optionsClause? ( 'table'? '(' procedureRsColumn ( ',' procedureRsColumn )* ')' | parseDataType ) )? optionsClause? ( 'as' statement )?

dropProcedure
         ::= 'drop' ( 'virtual' | 'foreign' )? ( 'procedure' | 'function' ) id

procedureParameter
         ::= ( 'in' | 'out' | 'inout' | 'variadic' )? id parseDataType ( 'not' 'null' )? 'result'? ( 'default' expression )? optionsClause?

procedureRsColumn
         ::= id parseDataType ( 'not' 'null' )? optionsClause?

createTable
         ::= 'create' ( createView | createForeignOrGloablTable )

createForeignOrGloablTable
         ::= ( 'foreign' | 'global' 'temporary' ) 'table' unqualifiedId createTableBody

createView
         ::= 'virtual'? 'view' unqualifiedId ( createViewBody | optionsClause )? 'as' queryExpression

dropTableView
         ::= 'drop' ( ( 'foreign' | 'global' 'temporary' ) 'table' | 'virtual'? 'view'
                  ) id

createForeignTempTable
         ::= 'create' 'local'? 'foreign' 'temporary' 'table' unqualifiedId createTableBody 'on' id

createTableBody
         ::= '(' createColumn ( ',' ( tableConstraint | createColumn ) )* ')' optionsClause?

createViewBody
         ::= '(' createViewColumn ( ',' ( tableConstraint | createViewColumn ) )* ')' optionsClause?

tableConstraint
         ::= ( 'constraint' id )? ( primaryKey | constraint | foreignKey ) optionsClause?

foreignKey
         ::= 'foreign' 'key' columnList 'REFERENCES' id columnList?

primaryKey
         ::= 'primary' 'key' columnList

constraint
         ::= ( 'unique' | 'accesspattern' ) columnList
           | 'index' '(' expressionList ')'

columnList
         ::= '(' id ( ',' id )* ')'

createColumn
         ::= id ( 'serial' | parseDataType ( 'not' 'null' )? 'auto_increment'? ) postCreateColumn

createViewColumn
         ::= id ( 'serial' | parseDataType ( 'not' 'null' )? 'auto_increment'? )? postCreateColumn

postCreateColumn
         ::= inlineConstraint? ( 'default' expression )? optionsClause?

inlineConstraint
         ::= 'primary' 'key'
           | 'unique'
           | 'index'

optionsClause
         ::= 'options' '(' optionPair ( ',' optionPair )* ')'

optionPair
         ::= id ( nonNumericLiteral | plusMinus? unsignedNumericLiteral )

alterOptionPair
         ::= id ( nonNumericLiteral | plusMinus? unsignedNumericLiteral )

alterStatement
         ::= 'alter' ( alterTable | alterProcedure | alterTrigger | alterServer | alterTranslator | alterDatabase )

alterTable
         ::= ( 'virtual'? 'view' | 'foreign'? 'table' ) id ( 'as' queryExpression | alterAddColumn | alterAddConstraint | alterOptionsList | alterDropColumn | 'alter' 'column' alterColumn | 'rename' ( alterRenameTable | 'column' alterRenameColumn ) )

alterRenameTable
         ::= 'to' id

alterAddConstraint
         ::= 'add' tableConstraint

alterAddColumn
         ::= 'add' 'column' createColumn

alterDropColumn
         ::= 'drop' 'column' id

alterColumn
         ::= id ( 'type' ( 'serial' | parseDataType ( 'not' 'null' )? 'auto_increment'? ) | alterChildOptionsList )

alterRenameColumn
         ::= id 'to' id

alterProcedure
         ::= ( 'virtual' | 'foreign' )? 'procedure' id ( 'as' statement | alterOptionsList | 'alter' 'parameter' alterColumn | 'rename' 'parameter' alterRenameColumn )

alterTrigger
         ::= 'trigger' 'on' id 'instead' 'of' ( 'insert' | 'update' | 'delete' ) ( 'as' forEachRowTriggerAction | 'enabled' | 'disabled' )

alterServer
         ::= 'server' id alterOptionsList

alterTranslator
         ::= ( 'data' 'wrapper' | 'translator' ) id alterOptionsList

alterDatabase
         ::= 'database' id alterOptionsList

alterOptionsList
         ::= 'options' '(' ( addSetOption | dropOption ) ( ',' ( addSetOption | dropOption ) )* ')'

dropOption
         ::= 'drop' id

addSetOption
         ::= ( 'add' | 'set' ) alterOptionPair

alterChildOptionsList
         ::= 'options' '(' ( addSetChildOption | dropChildOption ) ( ',' ( addSetChildOption | dropChildOption ) )* ')'

dropChildOption
         ::= 'drop' id

addSetChildOption
         ::= ( 'add' | 'set' ) alterChildOptionPair

alterChildOptionPair
         ::= id ( nonNumericLiteral | plusMinus? unsignedNumericLiteral )

importSchema
         ::= 'import' ( 'foreign' 'schema' id )? 'from' ( 'server' | 'repository' ) id 'into' id optionsClause?

importDatabase
         ::= 'import' 'database' id 'version' stringVal ( 'with' 'access' 'control' )?

identifierList
         ::= id ( ',' id )*

readGrantTypes
         ::= 'select'
           | 'insert'
           | 'update'
           | 'delete'
           | 'execute'
           | 'alter'
           | 'drop'

LINE_COMMENT
         ::= '--' [^#xD#xA]*

ALL_IN_GROUP
         ::= ID '.' '*'

ID       ::= QUOTED_ID ( '.' QUOTED_ID )*

QUOTED_ID
         ::= ID_PART
           | '"' ( '""' | [^"] )+ '"'

ID_PART  ::= ( '_' | '@' | '#' | LETTER ) ( LETTER | '_' | DIGIT )*

ESCAPEDFUNCTION
         ::= '{' 'fn'

ESCAPEDJOIN
         ::= '{' 'oj'

ESCAPEDTYPE
         ::= '{' ( 'd' | 't' | 'ts' | 'b' )

DECIMALVAL
         ::= DIGIT* '.' UNSIGNEDINTEGER

FLOATVAL ::= DIGIT '.' UNSIGNEDINTEGER [eE] ( '+' | '-' )? UNSIGNEDINTEGER

STRINGVAL
         ::= ( 'N' | 'E' )? "'" ( "''" | [^'] )* "'"

LETTER   ::= [a-zA-Z#x153-#xFFFD]

DIGIT    ::= [0-9]

UNSIGNEDINTEGER
         ::= DIGIT+

BINARYSTRINGVAL
         ::= 'X'
           | 'x' "'" ( HEXIT HEXIT )+ "'"

HEXIT    ::= [a-fA-F]
           | DIGIT

EOF      ::= $