Comment by convolvatron

pg logical replication is close to this. but ideally you want incremental query updates, which I believe Materialize provides.

but yes, I agree this is quite often what one wants, and would remove a lot of grot from the client