18.10.1 Syntax of query API

sql:

code

sql      ::= select_statement

select_statement:

code

select_statement
         ::= 'SELECT' selectcol_list 'FROM' table_list where_condition order_clause limit_clause ';'

referenced by:

selectcol_list:

code

selectcol_list
         ::= selectcolumn_exp FIELDNAME
           | '*'
           | COUNT '(' ASTERISK ')'

referenced by:

select_statement
selectcolumn_exp

selectcolumn_exp:

code

selectcolumn_exp
         ::= ( selectcol_list ',' )?

referenced by:

selectcol_list

table_list:

code

table_list
         ::= MODULENAME

referenced by:

select_statement

where_condition:

code

where_condition
         ::= ( 'WHERE' condition )?

referenced by:

select_statement

condition:

code

condition
         ::= expr_set expr

referenced by:

expr_set
where_condition

expr_set:

code

expr_set ::= ( condition ( 'AND' | 'OR' ) )?

referenced by:

condition

expr:

code

expr     ::= FIELDNAME logical_term valuelist

referenced by:

condition

valuelist:

code

valuelist
         ::= '(' valueref ')'
           | valueref

referenced by:

expr

valueref:

code

valueref ::= value_exp VALUE

referenced by:

value_exp
valuelist

value_exp:

code

value_exp
         ::= ( valueref ',' )?

referenced by:

valueref

logical_term:

code

logical_term
         ::= '='
           | '<'
           | '>'
           | '<='
           | '>='
           | '!='
           | 'IN'
           | 'LIKE'

referenced by:

expr

order_clause:

code

order_clause
         ::= ( 'ORDER BY' column_group clause )?

referenced by:

select_statement

column_group:

code

column_group
         ::= column_list

referenced by:

order_clause

column_list:

code

column_list
         ::= column_exp FIELDNAME

referenced by:

column_exp
column_group

column_exp:

code

column_exp
         ::= ( column_list ',' )?

referenced by:

column_list

clause:

code

clause   ::= ( 'ASC' | 'DESC' )?

referenced by:

order_clause

limit_clause:

code

limit_clause
         ::= ( 'LIMIT' limit_set )?

referenced by:

select_statement

limit_set:

code

limit_set
         ::= VALUE ( ',' VALUE )?

referenced by:

limit_clause