title: SQLite JSON1 example for JSON extract\set
body: <p>SQLite has now an experimental JSON1 extension to work with JSON fields. The functions to choose from look promising, but I don't get how to use them in the context of a query.</p>
  
  <p>Suppose I created the following table:</p>
  
  <pre><code>sqlite&gt; create table user(name,phone);
  sqlite&gt; insert into user values('oz', json_array(['+491765','+498973']));
  </code></pre>
  
  <p>The <a href="https://www.sqlite.org/json1.html" rel="noreferrer">documentation</a> shows how to use <code>json_each</code> in a query, but all other functions lack some in context documentation.</p>
  
  <p>Can someone with SQLite experience provide a few examples of how to use:</p>
  
  <ul>
  <li><code>json_extract</code></li>
  <li><code>json_set</code></li>
  </ul>