title: JSON_VALUE PATH EROR "JSON path is not properly formatted"
body: <p>I have a data table. I have a colon from the database. This column comes in the following format.</p>
  <pre><code>[{&quot;ID&quot;:1,&quot;Change&quot;:true,&quot;Painted&quot;:false},{&quot;ID&quot;:2,&quot;Change&quot;:true,&quot;Painted&quot;:false}]
  </code></pre>
  <p>I wanted to split this array into 3 different columns. I want the column with the ID as an array. So I used '$..ID' which uses JSON_VALUE. But I am getting error.</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>JSON_VALUE(X.VALUE,'$..ID') as ID,</code></pre>
  </div>
  </div>
  </p>