apps/server/src/checkpointing/Layers/CheckpointDiffQuery.test.ts                   | 105 ++++--------
 apps/server/src/checkpointing/Layers/CheckpointDiffQuery.ts                        |  22 ++-
 apps/server/src/orchestration/Layers/ProjectionSnapshotQuery.test.ts               | 286 ++++++++++++++++++++++++++++++++
 apps/server/src/orchestration/Layers/ProjectionSnapshotQuery.ts                    | 219 +++++++++++++++++++++++-
 apps/server/src/orchestration/Services/ProjectionSnapshotQuery.ts                  |  48 +++++-
 apps/server/src/persistence/Migrations.ts                                          |   2 +
 apps/server/src/persistence/Migrations/019_ProjectionSnapshotLookupIndexes.test.ts |  73 ++++++++
 apps/server/src/persistence/Migrations/019_ProjectionSnapshotLookupIndexes.ts      |  16 ++
 apps/server/src/serverRuntimeStartup.test.ts                                       |  41 ++++-
 apps/server/src/serverRuntimeStartup.ts                                            |  54 +++---
 10 files changed, 754 insertions(+), 112 deletions(-)