Chapter 3. SQL Support

JBoss Data Virtualization supports SQL for issuing queries and for defining view transformations.

JBoss Data Virtualization provides nearly all of the functionality of SQL-92 DML. SQL-99 and later features have been added as required. The following does not attempt to cover SQL exhaustively, but rather highlights SQL's usage within JBoss Data Virtualization.

See the appendix for the SQL grammar accepted by JBoss Data Virtualization.

See Section 3.9.2, “Command Statement” for information on how SQL is used in virtual procedures and update procedures.