Please avoid any hand-coded SQL.  Even if we need to break the query up into steps, I'd rather keep the queries only using the abstracted query syntax provided by Rails.