Module queries 

SQLite dialect-forked query modules per RFC-023 §4.1.

PG migrations and runtime queries cannot be shared with SQLite — the dialect gap (partitioning, RETURNING subsets, jsonb, etc.) requires a parallel module tree. This tree mirrors ff-backend-postgres one-for-one so parity review is a straight file-level diff.

Phase 2a.1 establishes the module layout. Method bodies land in Phase 2a.2 (attempt / exec_core) and Phase 2a.3 (lease / dispatch).

Modules

attempt

SQLite dialect-forked queries for the attempt hot path.

budget

Budget-family SQL — SQLite dialect port of ff-backend-postgres/src/budget.rs raw-SQL constants.

claim_grant

SQLite dialect-forked queries for RFC-024 ff_claim_grant table.

dispatch

SQLite dialect-forked queries for outbox writes + broadcast wakeup drains (RFC-023 §4.2).

exec_core

SQLite dialect-forked queries for execution core (create / claim / complete / fail).

flow

SQLite dialect-forked queries for flow-header create / cancel.

flow_staging

SQLite dialect-forked queries for flow-staging ingress (add_execution_to_flow, stage_dependency_edge, apply_dependency_to_child).

lease

SQLite dialect-forked queries for lease lifecycle (renew / reclaim).

operator

SQL statements for Wave 9 operator-control ops (RFC-023 Phase 3.2).

quota

Quota-family SQL — SQLite dialect port of the quota-policy INSERT used by create_quota_policy. RFC-023 Phase 3.4 / RFC-020 Wave 9 Standalone-1 §4.4.1.

reads

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

signal

SQL statements for signal delivery ops (RFC-023 Phase 2b.2.1).

stream

SQLite dialect-forked queries for the RFC-015 stream surface.

suspend

SQL statements for suspend + claim_resumed_execution ops (RFC-023 Phase 2b.2.1).

waitpoint

SQL statements for waitpoint + HMAC secret ops (RFC-023 Phase 2b.2.1).