title: Renaming nested fields in BigQuery query
body: <p>Nested fields in BigQuery are selected using the <code>dot</code> operator. </p>
  
  <p>I have change-data-captured tables with schemas that have a lot of nested fields. I would like to do something like this:</p>
  
  <pre><code>SELECT
     after.name as name, 
     after.age as age,
     after.address as address
  FROM [mytable]
  </code></pre>
  
  <p>without having to manually specify the <code>&lt;root.leaf&gt; as &lt;leaf&gt;</code> clauses. I'm looking for something like:</p>
  
  <pre><code>SELECT after.* as &lt;column suffix&gt; from `mytable`
  </code></pre>
  
  <p>Is this possible?</p>
  
  <p>EDIT: Additional info below</p>
  
  <p>Note that my goal here is to remove the <code>after</code> prefix in the field names of the output (i.e. <code>after.name</code> or <code>after_name</code> becomes <code>name</code>).</p>