Subquery cache roadmap

[sopel39]

https://github.com/trinodb/trino/pull/21888 introduces subquery cache feature to Trino engine. However, there are many follow up items to improve the performance and hit rate.

Here are the roadmap items:

### Tasks
- [ ] https://github.com/trinodb/trino/issues/22116
- [ ] https://github.com/trinodb/trino/issues/22117
- [ ] https://github.com/trinodb/trino/issues/22118
- [ ] https://github.com/trinodb/trino/issues/22119
- [ ] https://github.com/trinodb/trino/issues/22120
- [ ] https://github.com/trinodb/trino/issues/22121
- [ ] https://github.com/trinodb/trino/issues/22122