title: How to delete/update nested data in bigquery
body: <p>Is there a way to delete/update nested field in bigquery? </p>
  
  <p>Let's say I have this data</p>
  
  <pre><code>wives.age   wives.name  name     
  21             angel    adam     
  20             kale      
  21           victoria   rossi    
  20           jessica         
  </code></pre>
  
  <p>or in json:</p>
  
  <pre><code>{"name":"adam","wives":[{"name":"angel","age":21},{"name":"kale","age":20}]}
  {"name":"rossi","wives":[{"name":"victoria","age":21},{"name":"jessica","age":20}]}
  </code></pre>
  
  <p>As you can see from the data above. 
  Adam has 2 wives, named angel and kale. How to:</p>
  
  <ol>
  <li>Delete kale record.</li>
  <li>Update jessica to dessica</li>
  </ol>
  
  <p>I tried to google this, but can't find it. I also tried to unnest, etc but no luck. </p>
  
  <p>The reason why we want to do this is because we insert the array to the wrong records and want to remove/update array data with some condition.</p>