title: Insert data from Json table to the view that has been already created in SQL
body: <p>I have a problem, I have to insert data from a Json that stored in a table that has jus one field, just directly insert to the view but as I know there isn't any way to update or insert data into the view, do any one know how can I adjust or set my view to insert data from my table(PS: i can't use insert into or select into)</p>
  <p>my first table that has Json data:</p>
  <pre><code>|  JsonOutPut                                                                   |
  |-------------------------------------------------------------------------------|
  |[{&quot;FID&quot;:1,&quot;Fname&quot;:&quot;cake&quot;,&quot;Fcount&quot;:5,&quot;FDate&quot;:&quot;2020-02-13&quot;,&quot;Fregion&quot;:&quot;UK&quot;},...]  |
  </code></pre>
  <p>my view should be like this:</p>
  <pre><code>| FID | Fname | Fcount| FDate    | Fregion |
  |-----|-------|-------|----------|---------|
  |  1  | cake  |   5   |2020-02-13|    UK   |
  </code></pre>
  <p>I don't want create new table!</p>