SQL language

statement:
+statement:
       setStatement
   |   resetStatement
   |   explain
@@ -827,7 +827,7 @@ form.
   |   query
 
 setStatement:
-      [ ALTER ( SYSTEM | SESSION ) ] SET identifier '=' expression
+      [ ALTER ( SYSTEM | SESSION ) ] SET identifier '=' expression
 
 resetStatement:
       [ ALTER ( SYSTEM | SESSION ) ] RESET identifier
@@ -841,7 +841,7 @@ form.
 
 insert:
       ( INSERT | UPSERT ) INTO tablePrimary
-      [ '(' column [, column ]* ')' ]
+      [ '(' column [, column ]* ')' ]
       query
 
 update:
@@ -850,14 +850,14 @@ form.
       [ WHERE booleanExpression ]
 
 assign:
-      identifier '=' expression
+      identifier '=' expression
 
 merge:
       MERGE INTO tablePrimary [ [ AS ] alias ]
       USING tablePrimary
       ON booleanExpression
       [ WHEN MATCHED THEN UPDATE SET assign [, assign ]* ]
-      [ WHEN NOT MATCHED THEN INSERT VALUES '(' value [ , value ]* ')' ]
+      [ WHEN NOT MATCHED THEN INSERT VALUES '(' value [ , value ]* ')' ]
 
 delete:
       DELETE FROM tablePrimary [ [ AS ] alias ]
@@ -878,8 +878,8 @@ form.
 
 withItem:
       name
-      [ '(' column [, column ]* ')' ]
-      AS '(' query ')'
+      [ '(' column [, column ]* ')' ]
+      AS '(' query ')'
 
 orderItem:
       expression [ ASC | DESC ] [ NULLS FIRST | NULLS LAST ]
@@ -903,30 +903,30 @@ form.
 
 joinCondition:
       ON booleanExpression
-  |   USING '(' column [, column ]* ')'
+  |   USING '(' column [, column ]* ')'
 
 tableReference:
       [ LATERAL ]
       tablePrimary
-      [ [ AS ] alias [ '(' columnAlias [, columnAlias ]* ')' ] ]
+      [ [ AS ] alias [ '(' columnAlias [, columnAlias ]* ')' ] ]
 
 tablePrimary:
       [ TABLE ] [ [ catalogName . ] schemaName . ] tableName
-  |   '(' query ')'
+  |   '(' query ')'
   |   values
-  |   UNNEST '(' expression ')' [ WITH ORDINALITY ]
-  |   TABLE '(' [ SPECIFIC ] functionName '(' expression [, expression ]* ')' ')'
+  |   UNNEST '(' expression ')' [ WITH ORDINALITY ]
+  |   TABLE '(' [ SPECIFIC ] functionName '(' expression [, expression ]* ')' ')'
 
 values:
       VALUES expression [, expression ]*
 
 groupItem:
       expression
-  |   '(' ')'
-  |   '(' expression [, expression ]* ')'
-  |   CUBE '(' expression [, expression ]* ')'
-  |   ROLLUP '(' expression [, expression ]* ')'
-  |   GROUPING SETS '(' groupItem [, groupItem ]* ')'
+  |   '(' ')'
+  |   '(' expression [, expression ]* ')'
+  |   CUBE '(' expression [, expression ]* ')'
+  |   ROLLUP '(' expression [, expression ]* ')'
+  |   GROUPING SETS '(' groupItem [, groupItem ]* ')'
 
 windowRef:
       windowName
@@ -934,14 +934,14 @@ form.
 
 windowSpec:
       [ windowName ]
-      '('
+      '('
       [ ORDER BY orderItem [, orderItem ]* ]
       [ PARTITION BY expression [, expression ]* ]
       [
           RANGE numericOrIntervalExpression { PRECEDING | FOLLOWING }
       |   ROWS numericExpression { PRECEDING | FOLLOWING }
       ]
-      ')'

In merge, at least one of the WHEN MATCHED and WHEN NOT MATCHED clauses must be present.

Quoted identifiers, such as "Employee Name", start and end with double quotes. They may contain virtually any character, including spaces and other punctuation. If you wish to include a double quote in an identifier, use another double quote to escape it, like this: -"An employee called ""Fred"".".

In Calcite, matching identifiers to the name of the referenced object is case-sensitive. But remember that unquoted identifiers are implicitly @@ -1651,8 +1651,8 @@ name will have been converted to upper c

timeUnit:
-  YEAR | MONTH | DAY | HOUR | MINUTE | SECOND

aggregateCall:
+aggregateCall:
         agg( [ DISTINCT ] value [, value]* ) [ FILTER ( WHERE condition ) ]
-    |   agg(*) [ FILTER ( WHERE condition ) ]

If FILTER is present, the aggregate function only considers rows for which condition evaluates to TRUE.

If DISTINCT is present, duplicate argument values are eliminated before being +

If DISTINCT is present, duplicate argument values are eliminated before being passed to the aggregate function.