multiple tables query

Well you could try modelling the relationships in ActiveRecord, but I don't fully know how far Model.find .... goes in recursing those relationships. Ideally you want it all to come back in the one query.

Still if you have that kind of SQL, I think using the raw SQL query is the best choice. Rails allows you to do this, and even encourages you to do this when you outgrow what Rails gives you.