This sounds a bit like Jon Gjenset's thesis project Noria > Noria observes that, by having developers provide the set of queries their application will make in

This sounds a bit like Jon Gjenset's thesis project Noria > Noria observes that, by having developers provide the set of queries their application will make in advance, the database can be smarter about how to execute those queries. In particular, it can choose to pre-compute, and incrementally maintain, the results for queries. This allows Noria to answer those queries quickly, and essentially obviates the need for application caches. https://pdos.csail.mit.edu/projects/noria.html https://pdos.csail.mit.edu/projects/noria.html