Implement Query Objects for Complex Queries

[frogr]

Problem

Complex database queries are embedded in controllers and services.

Tasks

• Create query objects for user searches
• Extract subscription reporting queries
• Implement query result objects
• Add query caching layer

Acceptance Criteria

• Create app/queries/ directory
• Admin user listing uses query object
• Subscription queries extracted
• Query objects are testable in isolation
• All existing queries work correctly
• Add unit tests for query objects

Files to modify

• app/controllers/admin/users_controller.rb
• Various controllers with complex queries
• Create query object classes

Phase: 3 (Infrastructure)
Priority: Medium