title: How to "UNNEST" JSON objects in sql or bigquery?
body: <p>in my SQL server i have an attribute or column with this value</p>
  <pre><code>{&quot;cases&quot;: &quot;1&quot;, &quot;deaths&quot;: &quot;0&quot;, &quot;icuBeds&quot;: {&quot;capacity&quot;: &quot;&quot;, &quot;currentUsageCovid&quot;: &quot;&quot;, `&quot;currentUsageTotal&quot;: &quot;&quot;}, &quot;newCases&quot;: &quot;0&quot;, &quot;newDeaths&quot;: &quot;0&quot;, &quot;hospitalBeds&quot;: {&quot;capacity&quot;: &quot;&quot;, &quot;currentUsageCovid&quot;: &quot;&quot;, &quot;currentUsageTotal&quot;: &quot;&quot;}, &quot;negativeTests&quot;: &quot;&quot;, &quot;positiveTests&quot;: &quot;&quot;, &quot;contactTracers&quot;: &quot;&quot;, &quot;vaccinesDistributed&quot;: &quot;&quot;, &quot;vaccinesAdministered&quot;: &quot;&quot;, &quot;vaccinationsCompleted&quot;: &quot;&quot;, &quot;vaccinationsInitiated&quot;: &quot;&quot;}
  </code></pre>
  <p>I am trying run some SQL queries on this data in BigQuery however I just found out I cannot run any queries on these objects since the properties are stored as strings.</p>
  <p>This data is being inserted into my SQL server from my NODEJS server which is running api calls and storing the JSON formatted data into the SQL Server.</p>
  <p>What are some solutions I can do so that I can do some sql analysis in BigQuery? How can I store the data or how can I unnest the data so that I can access these properties?</p>