title: BigQuery : filter repeated fields with standard SQL
body: <p>I have the following table :</p>
  
  <pre><code>row | query_params | query_values
  1     foo            bar  
        param          val
  2     foo            baz 
  </code></pre>
  
  <p>JSON : </p>
  
  <pre><code>{ 
  "query_params" : [ "foo", "param"], 
  "query_values" : [ "bar", "val" ] 
  }, { 
  "query_params" : [ "foo" ], 
  "query_values" : [ "baz" ] 
  }
  </code></pre>
  
  <p>Using standard SQL I want to filter repeated field on their value, something like </p>
  
  <pre><code>SELECT * FROM table WHERE query_params = 'foo'
  </code></pre>
  
  <p>Which would output </p>
  
  <pre><code>row | query_params | query_values
  1     foo            bar  
  2     foo            baz       
  </code></pre>
  
  <p>PS : for the same question using legacy SQL, see <a href="https://stackoverflow.com/questions/41098239/bigquery-filter-repeated-fields-with-legacy-sql">here</a> </p>