DEV Community

Discussion on: ORM vs. SQL?

Collapse
 
dougmckechie profile image
Douglas McKechie

The SilverStripe CMS framework (silverstripe.org/) I use to create websites has an ORM which works really well.

Benefits are that the CMS can be used with different databases without needing changes any SQL code, it escapes variables used in queries, lazy loads records, has lots of helper functions such as filter, sort, limit etc, and in general means we write less code than if raw SQL was required so this speeds up development.

Fortunately is still possible to do Active Record style queries and even raw SQL when needed, which I have found is very infrequently.