DataSet-SQL is QTAssistant's internal SQL query engine for in-memory DataSet objects. DataSet-SQL is built on top of the comercial version of the QueryADataset library. While we do not offer this query engine as a standalone component, our consumers interact with it in many of our products, such as Query Designer, XML Schema Refactoring, Combinatorial Test Modeler, and Schema Analysis for Design Exceptions.
DataSet-SQL supports the most common SQL DML and DDL commands and styles of commands; for example, separating commands using a semicolon is supported.
The -- (double hyphen) and /* ... */ comment syntaxes are supported and can be embedded anywhere in a SQL statement.
It's possible that an exception is generated while issuing an UPDATE or a DELETE command, which may result in a partial change of a DataTable. Transactions are not supported, it is the caller that must use ADO.NET's AcceptChanges and RejectChanges methods to control accepting or rejecting of the changes (when scripting out commands).