That's what I've often wondered about ORMs. First they try to abstract away all the database internals so that the developer hardly even knows what's happening.

That's what I've often wondered about ORMs. First they try to abstract away all the database internals so that the developer hardly even knows what's happening. However, ultimately the abstraction always ends up having some limitations. In the end the internals need to be exposed, but since your code base is still mostly based around the ORM it can end up being a mess.