I know the NoSQL world had some progress in this space. RethinkDB was going in this direction around a decade ago if I recall. I would really like this from a modern relational database or data warehouse though. Polling sucks.
My feeling is that database needs to be built with replication in mind from the get-go to have something like this work well.