Formal Shape Grammar

<shape-command>

SHAPE <table-exp> [[AS] <alias>][<shape-action>]

<table-exp>

{<native-sql-statement>} |
(<shape-command>)

<shape-action>

APPEND <aliased-field-list> | 
COMPUTE <aliased-field-list> 
   [BY <field-list> [[AS] <alias>]] | 
BY <field-list> [[AS] <alias>]

<aliased-field-list>

<aliased-field> [, <aliased-field...]

<aliased-field>

<field-exp> [[AS] <alias>]

<field-exp>

(<relation-exp>) |
<calculated-exp>

<relation_exp>

<table-exp> [[AS] <alias>] 
   RELATE <relation-cond-list>

<relation-cond-list>

<relation-cond> [, <relation-cond>...]

<relation-cond>

<field-name> TO <child-ref>

<child-ref>

<field-name> | 
PARAMETER <param-ref>

<param-ref>

<number>

<field-list>

<field-name [, <field-name>]

<calculated-exp>

SUM(<qualified-field-name>) |
AVG(<qualified-field-name>) |
MIN(<qualified-field-name>) |
MAX(<qualified-field-name>) |
COUNT(<alias>) |
STDEV(<qualified-field-name>) |
ANY(<qualified-field-name>) |
CALC(<expresion>)

<qualified-field-name>

<alias>.<field-name> | 
<field-name>

<alias>

<quoted-name>

<field-name>

<quoted-name>

<quoted-name>

"<string>" | 
'<string>' | 
<name>

<name>

alpha [ alpha | digit | _ | # ...]

<number>

digit [digit...]

<string>

unicode-char [unicode-char...]

<expression>

An expression recognized by the Jet Expression service whose operands are other non-CALC columns in the same row.