Which SQL statements are supported by the JDBC Driver?

Please refer to the section "SQL Reference" of the JDataStore Programmers Guide for a complete answer to this.
The DataStore JDBC driver supports a subset of the ANSI/ISO SQL-92 standard. In general, it provides:

• Some Data Definition Language for managing tables and indexes, but no schema, domain, views, or security elements.
• Data manipulation and selection with INSERT, UPDATE, DELETE, and SELECT; but no cursors.
• No subqueries or JOINs (equi-joins are supported).