How can I see the SQL ActiveRecord generates?

Question

I'd like to check a few queries generated by ActiveRecord, but I don't need to actually run them. Is there a way to get at the query before it returns its result?

Answer 1

Both of these articles should help you do what you want.

http://weblog.jamisbuck.org/2007/1/8/watching-activerecord-do-it-s-thing

http://weblog.jamisbuck.org/2007/1/31/more-on-watching-activerecord

Answer 2

i think it's buried in:

construct_finder_sql,

http://groups.google.com/group/rubyonrails-talk/browse_frm/thread/38c492e3939dd9bf/?pli=1