We've absolutely loved using duckDB, have paired it with PRQL to enable writing really simple to read pipelines that can be composed easily.

Next up adding a caching layer in.

Anyone know if duckdb is considering adding some sort of caching mechanism? i.e. determining which queries or intermediate queries to store in-memory?

Would be interesting to write this as an extension