Performance and correctness rarely walk the same path — especially when filters live both in-memory and in database queries. Treating filtering as domain logic, not just query syntax, helps maintain clarity and testability while keeping performance flexible across boundaries.