I think turso in memory replicas might work here. They have some code to capture pg cdc to do that.

Likewise using something like pglite to run a pure pg in memory replica would be very cool