I think the most common problem with ORMs is that people doesn’t know when to use the ORMs functionality or when to write their own query. This always leads to

I think the most common problem with ORMs is that people doesn’t know when to use the ORMs functionality or when to write their own query. This always leads to N+1 problems and unmaintainable code, because when you eventually finds those problems it’s usually quick fixed because there’s no time for fixing all of it. It leads to ad hoc code for the next guy trying to change. This is generally not the ORMs fault, but always the programmer and that they don’t understand those limitations. Just replacing the same code with “raw” sql would produce the same thing but you need to write it all instead.