How do I turn on SQL debug logging for ActiveRecord in RSpec tests?

You could try setting the ActiveRecord logger to stdout in your test somewhere. If you’re using rspec, maybe in the spec helper?

ActiveRecord::Base.logger = Logger.new(STDOUT)