title: sqlite: Cannot select id while rowid works
body: <p>I have a database schema like this</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS 
      rephotos (id integer AUTO_INCREMENT, 
                beforePath text, 
                beforeThumbnail blob, 
                afterPath text, 
                afterThumbnail blob, 
                PRIMARY KEY(id)
                );
  </code></pre>
  
  <p>When trying to <code>SELECT</code> the ids in the database like this</p>
  
  <pre><code>SELECT id FROM rephotos;
  </code></pre>
  
  <p>it prints nothing. However if I use</p>
  
  <pre><code>SELECT rowid FROM rephotos;
  </code></pre>
  
  <p>it works as expected. The reason this confuses me is that the <a href="https://www.sqlite.org/autoinc.html" rel="nofollow">sqlite documentation</a> specifically states that</p>
  
  <blockquote>
    <p>If a table contains a column of type INTEGER PRIMARY KEY, then that
    column becomes an alias for the ROWID. You can then access the ROWID
    using any of four different names, the original three names described
    above or the name given to the INTEGER PRIMARY KEY column. All these
    names are aliases for one another and work equally well in any
    context.</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>