I feel these complaints are going to become a non-issue when we can write the optimal SQL then ask AI to do the conversion to ORM code. Or just ask AI to write the optimal ORM code with known data/performance considerations.
Essentially your code for talking to the database starts to look more and more like the code that deals with JSON responses, which all just look like quasi-idiomatic code in the programming language.