title: Extract Data From Array Google SQL
body: <p>I'm looking to extract a specific line of data from an array in Google SQL.</p>
  <p>I'm looking for suggestions on how to approach this!</p>
  <p>My data is structure like this <code>[id: int64, name: string, path: array{}]</code> &amp; the table is called <code>&quot;datatable&quot;</code></p>
  <p>I want to get the &quot;date_modified&quot; attribute in the array <strong>when &quot;status&quot; changes to &quot;closed&quot;</strong></p>
  <p><a href="https://i.stack.imgur.com/CpDBC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CpDBC.png" alt="enter image description here" /></a></p>
  <p>I would like to format my data such that it shows the ID, Name and the date_when it is marked as &quot;closed&quot;</p>
  <p><a href="https://i.stack.imgur.com/SdKxC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SdKxC.png" alt="enter image description here" /></a></p>
  <p>Any suggestions or solutions would be greatly appreciated!</p>