SQLite will assume an explicitly named integer primary key is just an alias for the rowid if the type is spelled out as "INTEGER" rather than "INT." I can simply change my create table statement as ...