title: Bigquery - json_extract all elements from an array
body: <p>i'm trying to extract two key from every json in an arry of jsons(using sql legacy)
  currently i am using json extract function :</p>
  
  <pre><code>json_extract(json_column , '$[1].X') AS X,
  json_extract(json_column , '$[1].Y') AS Y,
  </code></pre>
  
  <p>how can i make it run on every json at the 'json arry column', and not just [1] (for example)?</p>
  
  <p>An example json:</p>
  
  <pre><code>[
  
  {"blabla":000,"X":1,"blabla":000,"blabla":000,"blabla":000,,"Y":"2"},
  
  {"blabla":000,"X":3,"blabla":000,"blabla":000,"blabla":000,,"Y":"4"},
  
  ]   
  </code></pre>
  
  <p>thanks in advance!</p>