Talk at PDX.rb in May 2015 about SQL tricks in Rails https://github.com/pjungwir/rails-and-sql-talk February 6, 2019 Good Rails SQL activerecord tricks (including lateral join)