title: JSON_MODIFY Insert value in the json array by index
body: <p>Is there any insert or update value in json array by index.
  I have a column with such values:</p>
  
  <pre><code>["qwe","123"]
  </code></pre>
  
  <p>and I want to insert new value in the middle:</p>
  
  <pre><code>["qwe","asd","123"]
  </code></pre>
  
  <p>or remove one:</p>
  
  <pre><code>["123"]
  </code></pre>
  
  <p>how can it be done using <code>JSON_MODIFY</code>?</p>
  
  <p>I've only managed to append the last value:</p>
  
  <pre><code>select JSON_MODIFY([Column], 'append $', '')
  from MyTable
  </code></pre>
  
  <p>or update change the value in the middle to null:</p>
  
  <pre><code>select JSON_MODIFY([Column], '$[1]', NULL)
  from MyTable
  </code></pre>
  
  <p>and then REPLACE it to nothing.</p>