Open SQL for Java is based on entry level SQL, specified in ISO/IEC 9075, third edition 1992-11-01, Information technology - Database languages - SQL.
In addition to Entry level SQL, the following Intermediate SQL constructs are also supported:
Joined Tables
Dynamic Parameter Specification
Open SQL for Java supports the following subset of statements
Queries
Data manipulation language
More information about the Open SQL syntax: Open SQL Grammar