That is pretty much what Readyset does. The SQL parser identifies queries that are supported (and cached), and passes through all other requests to the backend database.

As we expand query support, we allow users to cache more and more queries.