Blog

How I built a single reusable query engine that handles any entity, any filter combination, any sort order — with full type safety, SQL injection protection, and cross-relation filtering baked in.

Window functions, materialized views, daily snapshots — and the difference between a leaderboard that merely works and one that stays fast when it actually matters.