Expressions¶

simpleExpression         ::= additiveExpression ( bitwiseOp additiveExpression )*
additiveExpression       ::= multiplicativeExpression ( addOp multiplicativeExpression )*
multiplicativeExpression ::= exponentExpression ( multOp multiplicativeExpression )*
exponentExpression       ::= unaryExpression [ "**" unaryExpression ]
unaryExpression          ::= [ "+" | "-" ] primaryExpression
primaryExpression        ::= integer
                             | float
                             | string
                             | "?"
                             | "(" simpleExpression ")"
                             | "ARRAY" "[" expressionList "]"
                             | functionCall
                             | objectName
expression               ::= andExpression ( "OR" andExpression )*
andExpression            ::= unaryLogicalExpression
                             | "(" expression ")" ( "AND" (
                             unaryLogicalExpression
                             | "(" expression ")"
                             ) )*
unaryLogicalExpression   ::= [ "NOT" ] relationalExpression
relationalExpression     ::= simpleExpression
                             [
                             relOp simpleExpression
                             | inClause
                             | betweenClause
                             | likeClause
                             | isNullClause
                             ]
expressionList           ::= expression ( "," expression )*
inClause                 ::= [ "NOT" ] "IN" "(" expressionList ")"
betweenClause            ::= [ "NOT" ] "BETWEEN" simpleExpression "AND" simpleExpression
likeClause               ::= [ "NOT" ] "LIKE" ( STRING | "?" )
isNullClause             ::= "IS" [ "NOT" ] "NULL"
functionCall             ::= objectName "(" [ expressionList | "*" ] ")"

selectExpression      ::= "SELECT" selectList
                          "FROM" tupleSourceExpression
                          [ "[" windowSpecification "]" ]
                          [ "WHERE" expression ]
                          [ "ORDER" [ "ASC" | "DESC" ] ]
                          [ "LIMIT" [ offset "," ] rowCount ]
mergeExpression       ::= "MERGE" tupleSourceExpression ( "," tupleSourceExpression )*
                          "USING" columnName
                          [ "ORDER" [ "ASC" | "DESC" ] ]
                          [ "LIMIT" [ offset "," ] rowCount ]
selectList            ::= selectItem ( "," selectItem )*
selectItem            ::= "*"
                          | simpleExpression [ [ "AS" ] columnName ]
tupleSourceExpression ::= objectName [ "HISTOGRAM" "(" columnName [ "," mergeTime ] ")" ]
                          | "(" streamExpression ")"
windowSpecification   ::= "SIZE" integer "ADVANCE" integer windowMode
windowMode            ::= "TIME" | "TUPLES" | "ON" columnName
offset                ::= integer
rowCount              ::= integer
mergeTime             ::= integer