Skip to main content

Module query_engine

Module query_engine 

Source
Expand description

Embedded SQL Query Engine for OverDrive InCode SDK

Parses and executes SQL queries directly against the embedded database. No server needed — runs entirely in-process.

§Supported SQL

  • SELECT [columns] FROM <table> [WHERE ...] [ORDER BY ...] [LIMIT n] [OFFSET n]
  • INSERT INTO <table> {json}
  • UPDATE <table> SET {json} [WHERE ...]
  • DELETE FROM <table> [WHERE ...]
  • CREATE TABLE <name>
  • DROP TABLE <name>
  • SHOW TABLES
  • SELECT COUNT(*) FROM <table> (and other aggregates)

Functions§

execute
Execute an SQL query against the embedded database