SELECT Statements

See SELECT Statements for a syntax reference and examples.

See Data Model for information on the capabilities of the API.

EXECUTE Statements

Use EXECUTE or EXEC statements to execute stored procedures. See EXECUTE Statements for a syntax reference and examples.

Names and Quoting

• Table and column names are considered identifier names; as such, they are restricted to the following characters: [A-Z, a-z, 0-9, _:@].
• To use a table or column name with characters not listed above, the name must be quoted using double quotes ("name") in any SQL statement.
• Strings must be quoted using single quotes (e.g., 'John Doe').