title: Getting an array of a parameter from repeated nested column in BigQuery
body: <p>I have a table where one column is defined as:</p>
  
  <pre><code>my_column ARRAY&lt;STRUCT&lt;key STRING, value FLOAT64, description STRING&gt;&gt;
  </code></pre>
  
  <p>Is there some easy way how to get an array of <code>value</code> parameters for each row using <code>SELECT</code> statement?</p>
  
  <p>Obviously, this does not work:</p>
  
  <pre><code>SELECT my_column.value
  FROM my_table
  </code></pre>
  
  <p>I could do it using <code>UNNEST</code> and then <code>ARRAY_AGG</code> grouping through all other columns but it just feels like a hack.</p>