Do you know about Electric SQL (https://electric-sql.com/docs/overview/technical-intro)? It sounds similar to what you describe.