I think you missed the parent's point - your USP is real-time replication. So everything you're proposing makes it not real time. Your USP is now worthless (in that context) and you're competitors are numerous.
What I am proposing above is ways to provide a view to teams that do not want real-time data while keeping your underlying dataset in real-time.