Skip to main content

Module reads

ff_backend_sqlite::queries

Module reads 

Source
Expand description

SQL statements for Wave 9 read-model methods (RFC-023 Phase 3.3).

Mirrors ff-backend-postgres/src/exec_core.rs §4.1 read impls at the statement level. SQLite translations:

  • LEFT JOIN LATERAL (... LIMIT 1) → LEFT JOIN on a correlated subquery expression. SQLite executes the subquery per-outer-row which is equivalent for LIMIT 1 projections.
  • FOR UPDATE — no-op under BEGIN IMMEDIATE single-writer.
  • BYTEA → BLOB. uuid column bound as 16-byte BLOB.
  • JSON extraction via json_extract (JSON1) instead of ->>.