title: return pair of values instead of one value from two queries
body: <p>I've got two queries that return single result. 
  They look something like this</p>
  
  <pre><code>// query 1
  SELECT A.id FROM tableA A
      INNER JOIN tableB B
          ON B.id = A.id
  WHERE b.status = 'ACTIVE'   
  
  // query 2
  SELECT C.id FROM tableC C
  WHERE c.status = 'ACTIVE'     
  </code></pre>
  
  <p>How to combine them and make return the pair of values instead of one value from different queries? I mean to get something like <code>[A.id, C.id]</code></p>
  
  <p>Currently I have to use two queries in the applications and I want to combine them into one.</p>