Rails activerecord to_sql_string?

Question

I've seen somewhere but can not remember. How to get a SQL string from an ActiveRecord object?

Client.find(1).to_sql_string

Answer 1

In Rails 3 you can use to_sql method

Client.first.to_sql
#=> some raw sql

Answer 2

I think you where looking at arel, which has a nice to_sql