What SQL Syntax Can Be Used with Devart ODBC Drivers?

What SQL Syntax Can Be Used with Devart ODBC Drivers?

Devart ODBC Drivers internally rely on the SQLite engine to execute SQL queries. This means that all SQL statements executed through the driver must conform to the SQLite SQL dialect.
The SQLite engine supports a wide range of SQL features including:
  1. Basic data retrieval (SELECT, WHERE, ORDER BY, LIMIT, etc.)
  2. Joins (INNER JOIN, LEFT JOIN)
  3. Aggregate functions (COUNT, SUM, AVG, etc.)
  4. Subqueries
  5. Common table expressions (CTEs) in newer versions
However, keep in mind that the specific support may depend on the database you are connecting to and the structure of its API.

For detailed guidance on supported syntax, refer to the official SQLite documentation:


This compatibility allows you to write flexible, efficient queries while ensuring the broadest support across various data sources via ODBC.