Engineering insights

Thoughts on building great software

Technical deep-dives, architecture decisions, lessons from the field, and honest takes on the state of software development.

⚙️
Engineering 12 June 2026 · 8 min read

Why we stopped using ORM queries for aggregations (and what we do instead)

After hitting serious performance walls on a client's analytics dashboard, we made a controversial call: write raw SQL for all aggregation queries. Here's what we learned six months later.