title: Insert default value for single field with SQLite
body: <p>Given the following table in SQLite:</p>
  
  <pre><code>CREATE TABLE users (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      name VARCHAR NOT NULL,
      hair_color VARCHAR NOT NULL DEFAULT 'Green'
  )
  </code></pre>
  
  <p>I'm attempting to perform a batch insert, using the default value for <code>hair_color</code> for only some of the rows. For example, in PostgreSQL or MySQL, it might look like:</p>
  
  <pre><code>INSERT INTO users (name, hair_color) VALUES
      ('Sean', 'Black'),
      ('Tess', DEFAULT)
  </code></pre>
  
  <p>However, SQLite does not provide a <code>DEFAULT</code> keyword in any other context beyond <code>DEFAULT VALUES</code>. I know that I can do this in two queries as</p>
  
  <pre><code>INSERT INTO users (name, hair_color) VALUES ('Sean', 'Black');
  INSERT INTO users (name) VALUES ('Tess');
  </code></pre>
  
  <p>However, I can't imagine that SQLite doesn't provide some mechanism to execute this in a single query. Is there any equivalent to the <code>DEFAULT</code> keyword from other backends for SQLite?</p>