This is the first public alpha release of the Microsoft open-source mssql-python driver!
Supported Platforms: Windows only (macOS and Linux support is coming soon)
Support for Microsoft Entra ID Authentication
DBAPI v2.0 Compliance: Fully compliant with the DB API 2.0 specification. Key aspects of DBAPI v2.0 compliance include:
- Connection Objects: Establishing and managing connections to the database.
- Cursor Objects: Executing SQL commands and retrieving results.
- Transaction Management: Supporting commit and rollback operations to ensure data integrity.
- Error Handling: Providing a consistent set of exceptions for handling database errors.
- Parameter Substitution: Allowing the use of placeholders in SQL queries to prevent SQL injection attacks.
Stay tuned for upcoming improvements and updates!