title: Does SQLite support SCOPE_IDENTITY?
body: <p>I'm trying to perform a simple INSERT and return the identity (auto-incrementing primary key). I've tried</p>
  
  <pre><code>cmd.CommandText = "INSERT INTO Prototype ( ParentID ) VALUES ( NULL ); SELECT SCOPE_IDENTITY();";
  </code></pre>
  
  <p>and I receive the following error</p>
  
  <pre>EnvironmentError: SQLite error
  no such function: SCOPE_IDENTITY</pre>
  
  <p>Does SQLite support SCOPE_IDENTITY?<br>
  If so, how do I use it?<br>
  If not, what are my (preferably "thread-safe") alternatives?</p>