SQL Support

The CData Virtuality Server supports SQL for issuing queries and for defining view transformations.

The CData Virtuality Server provides nearly all of the functionality of SQL-92 Data Manipulation Language (DML), and we continue to add SQL-99 and later features. This section does not attempt to cover SQL exhaustively: it aims at highlighting the usage of SQL within the CData Virtuality Server.

You can also find information on how SQL is used in virtual procedures and updating procedures in the Procedural Language section of our documentation.