Practical guides for converting raw SQL queries into correct, performant ActiveRecord code, including edge cases where Rails behaves differently than SQL.
,%20shot%20on%20Canon%20EOS%20R5,%20shallow%20depth%20of%20field%20f_2..jpg)
Rails INNER JOIN with multiple ON conditions — without moving predicates into WHERE by accident. .merge(), Arel, and SQL verification. Rails 7/8, 2026.
N+1 queries aren't a Rails flaw — they come from how you shape associations. Learn to spot the pattern early and fix it without over-eager loading.
ActiveRecord isn't SQL with Ruby syntax — it's a different mental model. Here's why the shift trips up SQL-fluent developers and how to make it click.