For example, I think what you describe is opting to inject a service to the domain that makes it indirectly talk to the database. In light of the "trilemma", we can imagine it sacrifices a little bit of purity (external dependency, stronger tie to the database schema) in order to keep things simpler -- and nothing wrong with that. In some cases performance could be affected too (ie. if the natural logic might want to update an entity twice during the course of a transaction).
But you still have "completeness" in that you can query your domain as one unit and handle logic within it.
I like that the "DDD Trilemma" acknowledges there is no universal, perfect solution for handling the object-relational mapping problem.