[raman162]

Yes I thought ActiveRecord's ORM addressed a lot of the pain the OP mentioned with traditional ORM's.

ActiveRecord is also the first and only ORM I've used extensively and I've been a fan of it. Prior to that, I used to stick to raw sql, most apps were smaller but even then it felt like a drain to write repetitive sql to find, insert and update records.