[Catalyst] What value does an ORM add?

[Perrin Harkins]

On Thu, 2006-06-08 at 08:33 -0700, Steve Atkins wrote:
> I'm comfortable with SQL, and with DBI. I write basic SQL that runs  
> just fine on all databases, or more complex SQL when I want to target  
> a single database (ususally postgresql).
> 
> What value does an ORM add for a user like me?

1) Stupidly simple SQL is written for you, e.g. CRUD queries for single
rows.  It may not sound like much, but you'd be surprised how much
pointless DBI code this can save you.

2) Your more complex SQL is organized so that the relevant queries for
dealing with a particular part of your data are easy to find.

3) By providing a consistent interface to your data, an ORM makes it
possible to do more code reuse, like building a standard search and
pager that works for many different tables in your database.

- Perrin