title: Bigquery: Append to a nested record
body: <p>I'm currently checking out Bigquery, and I want to know if it's possible to add new data to a nested table.</p>
  
  <p>For example, if I have a table like this:</p>
  
  <pre><code>[
      {
          "name": "name",
          "type": "STRING"
      },
      {
          "name": "phone",
          "type": "RECORD",
          "mode": "REPEATED",
          "fields": [
              {
                  "name": "number",
                  "type": "STRING"
              },
              {
                  "name": "type",
                  "type": "STRING"
              }
          ]
      }
  ]
  </code></pre>
  
  <p>And then I insert a phone number for the contact John Doe.</p>
  
  <pre><code>INSERT into socialdata.phones_examples (name, phone) VALUES("Jonh Doe", [("555555", "Home")]);
  </code></pre>
  
  <p>Is there an option to later add another number to the contact ? To get something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/HIkos.png" rel="noreferrer"><img src="https://i.stack.imgur.com/HIkos.png" alt="Append example"></a></p>
  
  <p>I know I can update the whole field, but I want to know if there is way to append to the nested table new values.</p>