Query Caching Policies

[domoritz]

The coordinator currently uses a LRU (least recently used) caching policy. Might it be possible to improve on this, for example by measuring latency, dataset size, or other statistics to more intelligently optimize the cache eviction policy? This project would develop alternative caching schemes and analyze their effectiveness relative to realistic workloads. One could consider both pure client-side approaches, or approaches that also leverage a backing data server.

[derekperkins]

Once this lands, we should be able to leverage client-side device storage for significantly larger cache sizes

• Add OPFS support duckdb/duckdb-wasm#1490