ActiveRecord Raw SQL

activerecord-raw-sql

@results = []
ActiveRecord::Base.connection.select_all(
  ActiveRecord::Base.send(:sanitize_sql_array, 
   ["select * from events where area_type = ? and area_id = ?", 'parcel', '1'])
).each do |record|
  # instead of an array of hashes, you could put in a custom object with attributes
  @results << {id: record["id"], category: record["category"]}
end