[polemic]

These are limitations of specific ORMs or ORM classes, not of the concept in general.

> Another point: your ORM would automatically pick up changes to your model and cope with it, not your hand-written SQL, making your code harder to maintain.

You mean, I'd need to re-write LESS hand-written SQL with model changes. This is a selling point, not a down side.