PyODBC is Microsoft's recommended DBAPI layer for connecting a python application to MSSQL. However, the layer is not MSSQL-specific, and so it has some limitations ...