Interesting. What would you say the use case is for this, rather than setting up read replicas? Not having to maintain routing to the replicas on the application side?
You can read more about how it works here: https://docs.readyset.io/concepts/overview
The same query could produce wildly different result based on the user issuing them, and the caching somehow has to take that into account. Is that something you address?
https://people.csail.mit.edu/malte/pub/papers/2019-hotos-mul...