Post.join(:author).where(:author__name => "John")
In any case, it lets you drop into raw SQL as a last resort.
In any case, it lets you drop into raw SQL as a last resort.