<pre>sqlite> .mode table
sqlite> INSERT INTO "test"("name") VALUES ('johnny2') RETURNING id,name;
+----+---------+
| id | name |
+----+---------+
| 4 | johnny2 |
+----+---------+
sqlite> INSERT INTO "test"("name") VALUES ('johnny3') RETURNING "id","name";
+----+---------+
| id | name |
+----+---------+
| 6 | johnny3 |
+----+---------+ </pre>
I suspect this bug, if it is a bug, is in System.Data.SQLite . You have posted useful version numbers, so someone familiar with it should be able to help.