Query Planter vs Quere Optimizer

There's a certain kind that there are some analogies here, in the sense that essentially things like transaction management, joins referenc, maintaining referential integrity, ends up being moved from the data base to the application level. So if you're using the saga pattern, some aspects of what you're doing are more complicated with and then querying is more complicated,. You're now having to enforce those at the applicationlevel. But on the other hand, the assumption is that there are benefits to splitting up, right? And hopefully that the benefits outweigh the drawbacks.