Supported SQL subset

add-column-set : add-column-spec | ( add-column-spec-comma-list )

add-column-spec : column-identifier data-type

boolean-factor : [ NOT boolean-primary ]

boolean-primary : predicate | ( search-condition )

boolean-term : boolean-factor [ AND boolean-term ]

column-definition : column-identifier data-type [ NOT NULL ]

column-identifier : user-defined-name

column-value : literal | NULL

comparison-operator : < | > | <= | >= | = | <>

comparison-predicate : column-identifier comparison-operator literal

data-type : BIT | [ UNSIGNED ] TINYINT | [ UNSIGNED ] SMALLINT | [ UNSIGNED ] INTEGER | COUNTER | BIGINT | REAL | FLOAT | DOUBLE [ PRECISION ] | DATE | TIME | TIMESTAMP | CHAR [ (n) ] | VARCHAR [ (n) ] | LONG VARCHAR | BINARY [ (n) ] | VARBINARY [ (n) ] | LONG VARBINARY

date-literal : #{exact date expression}#

Valid date and time expressions are those which can be parsed by the Parse() member function of the TTime class.

digit : 0 | 1 | 2 | ... 8 | 9

drop-column-set : column-identifier | ( column-identifier-comma-list )

index-name : user-defined-name

letter : a | b ... y | z | A | B ... Y | Z

like-predicate : column-identifier [ NOT ] LIKE pattern-value

literal : string-literal | numeric-literal | date-literal

null-predicate : column-identifier IS [ NOT ] NULL

numeric-literal : {exact numeric types}

Valid numeric forms are those which can be parsed by the Val(TInt64&) and Val(TReal&) member functions of the TLex class.

pattern-value : string-literal

Non SQL-standard characters in the pattern value are used as wildcards:

• question mark (?) represents any single character

• asterisk (*) represents zero or more characters

Standard SQL uses the underscore (_) and percent (%) characters respectively.

predicate : comparison-predicate | like-predicate | null-predicate

search-condition : boolean-term [ OR search-condition ]

select-list : * | column-identifier-comma-list

sort-specification : column-identifier [ ASC | DESC ]

string-literal : '{character}'

Character strings can contain any text character. A single quote character (') can be embedded by using two single quote characters.

table-name : user-defined-name

update-column : column-identifier = column-value

user-defined-name : letter [ letter | digit | _ ]...