Please read for an updated status on RailsCasts:
Learn more or hide this
GitHub User: bradphelan
There is a big win when using a ruby based DSL for SQL. For basic queries it doesn't make a huge difference but when building a complex data querying module being able to compose queries out of smaller pieces is very useful.
I built rocket_tag on top of squeel as an example of how to use complex query building techniques in rails.
I've used Squeel exclusively for developing my tagging library. Compared to acts as taggable on steriods the code is very readable.
It makes writing composable SQL a breeze.