The API Profile supports several operations on profile data, including selecting and executing procedures.
The API Profile supports SQL-92 Syntax. SELECT Statements includes a comprehensive list of the suported keywords and clauses, as well as syntax reference and examples.
In addition to standard SELECT statement clauses, the API Profile supports additional functionaliy. See SQL Functions for documentation and examples of SQL functions that are supported in SELECT queries, including STRING Functions, DATE Functions and MATH Functions.
Use EXECUTE or EXEC statements to execute stored procedures, when functionality cannot be represented diretly as a SELECT, INSERT, UPDATE or DELETE statement. See EXECUTE Statements for a syntax reference and procedure examples.