SQLite Forum

Non primary key alias to rowid
Why do you need a Text primary key for sessions? I think that is the problem with your definition.

A Text 'Primary Key' for a table using row-ids is not really the primary key for the table, but the real primary key will be the row-id, and the text key will really just be a unique key.

There is no such thing as a non-primary key alais for the ROWID, as by definition if the ROWID exists in the table, it IS the Primary Key for the table.