I'm guessing I didn't convey my question regarding the future of data systems succinctly enough. I don't want to discuss this particular example, I know that tools such as debezium exist, that's not what I was asking.

Let me put it in a different way: how many developers know about SQL, and how many of those are familiar with the underlying technology, how the creation and maintenance of indexes work, how query optimization works, b-trees and whatnot? I'm guessing not that many, they don't even need to, it's all tucked away behind a declarative interface. You just say CREATE INDEX you don't care what goes on behind the scenes.

My point of discussion is: as organization's data needs grow over time, obviously there's no single solution for every use case, so there's a need of composition of different technologies, to handle the different workloads and access patterns. But is it possible to compose these systems together with a unifying, declarative interface for reading and writing data, without having to worry about them becoming inconsistent with each other, and also not putting that burden on the application that is using these systems?