ruby 32 lines · 2 tabs

Query objects for complex ActiveRecord queries

Alex Kumar Jan 2026

2 tabs

class PopularPostsQuery
  def initialize(relation = Post.all)
    @relation = relation
  end

  def call(timeframe: 7.days, min_views: 100, limit: 20)
    @relation
      .joins(:author)
      .where('posts.created_at >= ?', timeframe.ago)
      .where('posts.views >= ?', min_views)
      .where('users.status = ?', 'active')
      .where(posts: { published_at: ...Time.current })
      .select('posts.*, (posts.views * 0.6 + posts.likes_count * 0.4) AS popularity_score')
      .order('popularity_score DESC')
      .limit(limit)
  end
end

module Api
  module V1
    class PostsController < BaseController
      def popular
        posts = PopularPostsQuery.new.call(
          timeframe: params[:timeframe]&.to_i&.days || 7.days,
          min_views: params[:min_views]&.to_i || 100,
          limit: params[:limit]&.to_i || 20
        )

        render json: posts
      end
    end
  end
end

2 files · ruby Explain with highlit

When queries become too complex for scopes—involving multiple joins, subqueries, or raw SQL fragments—I extract them into dedicated query objects. Each query object is a plain Ruby class that encapsulates one specific query pattern and returns an ActiveRecord::Relation so results remain composable. This keeps models lean and makes testing easier since I can verify query logic in isolation. Query objects also improve performance visibility—I can instrument them with logging or metrics to track slow queries. The pattern works particularly well for search and reporting features where query complexity grows over time. I prefer query objects over putting everything in scopes when the logic exceeds 3-4 lines.

Related snips

ruby

class CommentsController < ApplicationController
  before_action :set_post

  def create
    @comment = @post.comments.build(comment_params)

System test: asserting Turbo Stream responses

rails hotwire turbo

by codesnips 4 tabs

ruby

class Post < ApplicationRecord
  belongs_to :author, class_name: 'User'
  has_many :comments, dependent: :destroy

  scope :published, -> { where.not(published_at: nil).where('published_at <= ?', Time.current) }
  scope :draft, -> { where(published_at: nil) }

ActiveRecord scopes for reusable query logic

rails activerecord patterns

by Alex Kumar 1 tab

ruby

module Api
  module V1
    class UsersController < BaseController
      def show
        user = User.includes(:profile).find(params[:id])

ETags for conditional requests and caching

rails caching http-caching

by Alex Kumar 1 tab

ruby

class PostsController < ApplicationController
  def index
    @posts = Post.includes(:author)
                 .order(created_at: :desc)
                 .page(params[:page])
                 .per(10)

Turbo Frames: infinite scroll with lazy-loading frame

rails turbo hotwire

by codesnips 4 tabs

ruby

require "csv"

class PeopleCsvStream
  include Enumerable

  HEADERS = %w[id full_name email signed_up_at plan].freeze

Resilient CSV Export as a Streamed Response

rails performance streaming

by codesnips 3 tabs

erb

<form data-controller="query-sync" data-action="change->query-sync#apply">
  <select name="status" class="rounded border p-2">
    <option value="">Any</option>
    <option value="open">Open</option>
    <option value="closed">Closed</option>
  </select>

Filter UI that syncs query params via Stimulus (no front-end router)

rails hotwire stimulus

by Henry Kim 2 tabs

Share this code

Here's the card — post it anywhere.

Query objects for complex ActiveRecord queries — share card

Link copied