Advantages of ORM

Thanks. In response to 1. I only use MySQL. Also when I look at code like ->select(‘name’)->from(‘table’)->where(‘age < 10’) in my mind I just read that as as query anyway (SELECT name FROM table WHERE age < 10). If you aren’t bothered about that do you think the other two reasons are strong enough to warrant using them?

How common is it to use ORM? Do most of the major frameworks and CMSs use them?

There are tools that build the database schema for you, from the objects you’ve mapped.

I was looking at Propel and it looks like you have to declare relations in a XML file. When you say it builds the schema, what do you mean?

Thanks.