title: Presto - select all columns from unnested column along with regular column
body: <p>I have an athena table(created from json data dump) which has a nested array in one column. I am able to unnest them using the below query.</p>
  
  <pre><code>select root.Profile,
  addressdata.town, addressdata.territory, addressdata.postalCode, addressdata.country, 
  street.addressLine1, street.addressLine2, street.door, streetID, addressID
  From 
  sampletable a 
  CROSS JOIN UNNEST(root.address.primaryAddresses) WITH ORDINALITY as t(addressdata, addressID)
  CROSS JOIN UNNEST(addressdata.streetAddress) WITH ORDINALITY as t(street, streetID)
  </code></pre>
  
  <p>The problem is, instead of using <code>addressdata.town</code>, <code>addressdata.territory</code>, i would like to select all the columns without mentioning the column names along with the regular nonnested columns.</p>
  
  <p>I tried  <code>select root.profile, addressdata.*</code> but this is returning everything in a single column.</p>
  
  <p>Please help!</p>