ORMs only make easy things slightly easier. Complex queries are not expressable in ORMs, so you need SQL queries (usually as strings, in external files or generated with a tool like jOOQ/LINQ).
I think just doing all with SQL is easier to understand and maintain.
I see no benefit of ORM considering the small benefits vs cost of learning.
Agree 85%. 10% relates to cases where you want dynamically- generated queries, which is why Phrebar has facilities to help with this.
No off-the-shelf ORM that I've ever used has done anything but get in the way.
Another 5% disagreement over whether they even make easy things easy. They often require some contortion of your application code in order to work at all, like annotations or inheritance on value objects that lead to them being coupled to a specific data source.
I think just doing all with SQL is easier to understand and maintain.
I see no benefit of ORM considering the small benefits vs cost of learning.
And your code become hugely dependent on them.