View source for SQL Syntax Considerations

__NOINDEX__
;Considerations:
:* SQL syntax is not case-sensitive, except for table names and field names.
:* Backticks are (<tt>`</tt>) are needed around any table or field name that is one of the [[SQL Reserved Words]].
:: For example: <tt>SELECT * FROM `Order`</tt>
:: Without the backticks, you get an error like this:
::: <tt>Encountered "Order" at line column 15. Was expecting one of (...</tt>
:: That error means the parser found a word it recognized, but didn't find other things it expected before it got to that word.
:* When either a table name or a field name is reserved word, and both are used together, then backticks are needed around the combination. 
:: For example: <tt>`Order.order_number`</tt>
<!--
:* When you double-click an Object table, backticks are (<tt>`</tt>) added around the table name in the SQL expression.
:: They're needed when the table name turns out to be in the (fairly lengthly) list of [[SQL Reserved Words]].
:: For example: 
::: <tt>SELECT * FROM `ORDER`</tt>
:: Without the backticks, you get an error like this:
:::<tt>Encountered "Order" at line 1, column 15. Was expecting (...</tt>
::which means that parser found a word it recognized, but didn't find other things it expected before it got to that word.
-->