title: How do you use an IN subquery on a dynamic list in SQL?
body: <p>I am making a query on google Big Query and I'm trying to add in a variable table to make changing what my query is selecting much easier but I'm running into the following error when making my query:</p>
  
  <p><code>Cannot execute IN subquery with uncomparable types INT64 and STRUCT&lt;INT64, INT64&gt;</code></p>
  
  <p>With the query being:</p>
  
  <pre><code>WITH vars AS (
    SELECT (3,6) as ids
  )
  SELECT id FROM users
  WHERE id IN (SELECT ids FROM vars);
  </code></pre>
  
  <p>Which is confusing because I thought that's exactly what the <code>IN</code> subquery was for. I don't understand why that query fails while the following query works just fine:</p>
  
  <pre><code>SELECT id FROM users
  WHERE id IN (3,6);
  </code></pre>
  
  <p>What's the issue here and is there a work around?</p>