Ledger & Graph Analytics

This module focuses on correctness constraints in financial data and reachability in graphs.

Window functions + aggregates

• Keep posted vs pending state clear.
• Balance as-of dates are filters, not partitions.

Recursive CTEs

• Cap depth for bounded traversals.
• Deduplicate nodes by minimal hop depth.