title: How to save the result of sql query against caches into another cache
body: <p>I have two caches, and I did a join between these two caches. Then what is the recommended/efficient way to save the result of this join query into the 3rd cache?</p>
  
  <p>I would like not to do it by iterating over the query result and put each into the cache,but would like to use sql like</p>
  
  <pre><code>insert into thirdcache select colomns from firstcache join secondcache
  </code></pre>