Multi-CTE snapshot reconciliation pipeline. Practice deriving event-state at every snapshot date using only events with posted_at <= snapshot_date (simulating what the warehouse 'knew' at snapshot time), comparing against the actual snapshot table, and producing a drift report ranked by impact. The path's marquee 'reconciliation as moat' mission.