Supported SQL statements

The following table describes SQL statements supported by the driver.

SQL statement	Description
SELECT	Retrieves data from a database without modifying it. Key components include FROM (specifying data source), WHERE (filtering rows), GROUP BY and HAVING (grouping and aggregating data), DISTINCT (removing duplicates), ORDER BY (sorting results), and LIMIT (restricting rows) clauses. Supports compound queries (UNION, INTERSECT, EXCEPT) and advanced features like WITH (defining common table expressions) and table-valued functions.
UPDATE	Modifies values in one or more rows of a table. If WHERE is omitted, all rows are updated; otherwise, only matching rows. The SET clause assigns new values, and if a column is updated multiple times, the last assignment is applied. Supports OR clauses for conflict resolution, UPDATE FROM for updates based on other tables, and optional LIMIT and ORDER BY for controlled modifications.
INSERT	Adds new rows to a table. The INSERT statement has three basic forms: INSERT INTO table VALUES (...) – Inserts explicit values. INSERT INTO table SELECT ... – Inserts rows from a SELECT query. INSERT INTO table DEFAULT VALUES – Inserts a row with default values. Supports REPLACE, INSERT OR <action> for conflict handling. The AS alias can be used for reference.
DELETE	Removes rows from a table. If a WHERE clause is provided, only matching rows are deleted; otherwise, all rows are removed. ORDER BY and LIMIT can control deletions if enabled.