title: Insert into a table and set another column to autoincremented column value
body: <p>Let's say I have a simple table:</p>
  
  <pre><code>create table foo
  {
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      bar INTEGER
  }
  </code></pre>
  
  <p>And I want to insert a new row, such that <code>id == bar</code> where value for <code>id</code> is chosen by the database, a.k.a. auto-increment.</p>
  
  <p>Something like this:</p>
  
  <pre><code>INSERT INTO foo (id, bar) VALUES (NULL, id)
  </code></pre>
  
  <p>Is it possible do this in one statement?</p>
  
  <p>What is the SQL syntax for that?</p>