title: extract value from a column presto
body: <p>i have two columns: </p>
  
  <pre><code>col1: Adam Smith
  col2: [{"productId":"328608","invoiceId":"16150101","productType":"car"}]
  </code></pre>
  
  <p>i need to select this:</p>
  
  <pre><code>col1: Adam Smith
  ProductId: 328608
  </code></pre>
  
  <p>any ideas?</p>
  
  <p>Thanks.</p>