title: How to declare a struct type variable in Big Query?
body: <p>I have a query with a couple of nested tables and all of them use a filter like this:</p>
  
  <pre><code>WHERE
      DATE(my_time) IN ("2017-08-12", "2017-08-13", "2017-08-14", ..., "2017-08-30")
  </code></pre>
  
  <p>I am trying to declare a STRUCT type variable in the start of the query with all the dates
  so that I can later replace all filters with:</p>
  
  <pre><code>WHERE
      DATE(my_time) IN struct_var
  </code></pre>
  
  <p>I am looking for something like this: </p>
  
  <pre><code>DECLARE struct_var STRUCT &lt;"2017-08-12", "2017-08-13", "2017-08-14", ..., "2017-08-30"&gt;;
  </code></pre>
  
  <p>but I keep getting errors and can't figure out the syntax.</p>
  
  <p>Anyone knows how to fix this?</p>
  
  <p>Thanks</p>