Topic: pros & cons of using find_by_sql

What are some of the advantages and dis-advantages of using find_by_sql in rails?

Thanks.

Re: pros & cons of using find_by_sql

find_by_sql defeats the purpose of mapping database tables to objects.
It's there for the extremely rare case that you need it.

Re: pros & cons of using find_by_sql

I agree with toddg, the basic purpose of mapping data base die because of it.