rails-query-object

Encapsulate complex Rails ActiveRecord queries into reusable query objects by defining dedicated classes in app/queries that accept a context and return relations or hashes. This isolates query logic for better testability and maintenance.

Test complex database queries in Rails by writing a failing spec in spec/queries first, then implementing the query object class in app/queries. Run the tests to verify GREEN before integrating the logic into controllers or services.

Handle multi-tenant scoped queries in Rails by using query objects that accept an account or user context in their constructor. This ensures all aggregated statistics and dashboard data are automatically scoped to the correct tenant.

Use query objects instead of standard ActiveRecord scopes when you need to encapsulate complex database queries for dashboards, reports, and aggregated statistics. They provide isolated, testable logic that prevents fat models or controllers.

Yes, query objects can return hashes instead of ActiveRecord relations for Rails reports. The constructor accepts a context like an account or user, allowing flexible data structures for aggregated statistics and dashboard rendering.