I decided to also add MS SQL Server to my application and it was recommended to use pyodbc, so that was what I went with. I have ran into an issue though, with MySQL and another db connection package ...

The primary key column is often set to auto-increment when constructing a SQL Server database. To achieve this, the IDENTITY property is enabled on the primary key column. The starting value and ...