IME if ActiveRecord is not sufficient, you go directly to SQL.

find_by_sql gives you enough freedom to get everything out of the db into a ActiveModel object.