It's just code, compiled into a library that you can use, and queries are either logged by the library or in your database. What exactly is so impenetrable? That's just strange. Also CRUD is the ideal scenario for ORMs which handle all the mapping, security, parameterization, and even conversions between data types and models seamlessly while letting you just work with your objects.
It seems you either didn't use ORMs correctly or used a very poor one.
It seems you either didn't use ORMs correctly or used a very poor one.