SQLite will auto-increment the primary key if it's declared as INTEGER PRIMARY KEY, even without the keyword AUTOINCREMENT.

References:

• https://www3.sqlite.org/autoinc.html

• https://www.slingacademy.com/article/demystifying-sqlite-autoincrement-and-row-ids/