title: SQLite UPDATE syntax with field list
body: <p>I would like to update an existing row in SQLite using the following syntax:</p>
  
  <pre><code>UPDATE "table_name" SET ("field_1", "field_2") = ('value_1', 'value_2') WHERE "field_3"='value_3';
  </code></pre>
  
  <p>The <a href="https://sqlite.org/lang_update.html" rel="nofollow noreferrer">official documentation</a> suggests this should be possible, where the UPDATE statement must conform to this:</p>
  
  <p><a href="https://i.stack.imgur.com/KMwL2.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KMwL2.gif" alt="SQLite UPDATE syntax diagram"></a></p>
  
  <p>Which gives me this:</p>
  
  <pre><code>UPDATE qualified_table_name SET column_name_list = expr WHERE expr;
  </code></pre>
  
  <p>Where <code>column_name_list</code> must be:</p>
  
  <p><a href="https://i.stack.imgur.com/YEIYf.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YEIYf.gif" alt="SQLite UPDATE column_name_list"></a></p>
  
  <pre><code>(column_name, column_name)
  </code></pre>
  
  <p>And where first <code>expr</code> can be:</p>
  
  <pre><code>(expr, expr)
  </code></pre>
  
  <p>But when I plug them all together (as in my first code snippet) SQLite gives me a syntax error:</p>
  
  <pre><code>near "(": syntax error:
  </code></pre>
  
  <p>Is this format possible? What am I doing wrong?</p>