クエリに発行元のコメントを含める処理の簡易版

active_record_dowsing.rb

# frozen_string_literal: true

dowsing = Module.new do
  def execute(sql, *)
    source_location = query_source_location(caller.lazy)
    sql = "#{sql} /* #{source_location} */" if source_location
    super
  end

  private

  def query_source_location(locations)
    source_location = ActiveRecord::LogSubscriber.backtrace_cleaner.clean(locations).first
    source_location&.remove!('*')
    source_location
  end
end

ActiveSupport.on_load(:active_record) do
  ActiveRecord::ConnectionAdapters::Mysql2Adapter.prepend(dowsing)
end