Explicit relationships
Indexlume reads primary keys, unique keys, foreign keys, and indexes from PostgreSQL. A projection declares root identity, relation paths, selected fields, cardinality, and aggregation behavior instead of accepting arbitrary SQL.
Immutable published versions
Drafts use optimistic concurrency. Validation records a schema fingerprint; publishing creates an immutable active version and schedules a snapshot job. Changes are reviewed as a new version.
Guarded reconciliation
Hard-delete reconciliation is a separate preview-and-confirm flow with candidate digests, bounded execution windows, and audit records. Incremental processing uses checkpoint-safe replay after interruption.
Build a relational projection