title: Is it possible to make ActiveRecord create objects for rows loaded using the :joins option?
body: <p>I need to do something like this </p>
  
  <pre><code>class User &lt; ActiveRecord::Base
    has_many :abuse_reports
  end
  
  class AbuseReport &lt; ActiveRecord::Base
    belongs_to :abuser, :class_name =&gt; 'User', :foreign_key =&gt; 'abuser_id'
    belongs_to :game
  end
  
  class Game &lt; ActiveRecord::Base
    has_many :abuse_reports
  end
  
  @top_abusers = User.page(params[:page], 
    :joins =&gt; [
      'JOIN abuse_reports ON users.id = abuse_reports.abuser_id', 
      'JOIN games ON games.id = abuse_reports.game_id'
    ], 
    :group =&gt; 'users.id',
    :select =&gt; 'users.*, count(distinct games.id) AS game_count, count(abuse_reports.id) as abuse_report_count',
    :order =&gt; 'game_count DESC, abuse_report_count DESC'
  )
  </code></pre>
  
  <p>This works, but doesn't create objects for AbuseReports or Games - it just returns a pile of rows. When I reference these objects from my view it loads them again. Is there a way to fix this? Or some way to get this behavior without using :joins?</p>