citadeldb-sql

SQL engine for the Citadel encrypted embedded database engine. Supports CREATE/DROP TABLE, ALTER TABLE, TRUNCATE, SELECT with JOINs, subqueries, CTEs (recursive + WITH-DML), window functions, INSERT (with UPSERT / ON CONFLICT), UPDATE, DELETE, RETURNING (with OLD/NEW row aliases), generated columns (STORED + VIRTUAL), partial indexes (CREATE INDEX … WHERE), foreign keys with full referential actions (CASCADE / SET NULL / SET DEFAULT / RESTRICT / NO ACTION), aggregates, constraints, transactions with savepoints, prepared statements, and multi-statement scripts.

This crate is part of the Citadel workspace. Depend on the main citadeldb crate instead.

License

MIT OR Apache-2.0