Ability to use multiple table caches in a SQL definition

[NithinKumaraNT]

Currently, it is only possible to select and parameterise the output of a request based on a single cache table using,
{{cache.schema}}.{{cache.table}}

It would be great if we can refer to a particular cache.
This helps to avoid caching more than once in case of unions or joins if needed.