microsoft/mssql-python v0.13.0-preview

v0.13.0-preview

Repository: microsoft/mssql-python

Tag: v0.13.0-preview

Published: 2025-10-01T15:12:33Z

Prerelease: yes

Release notes:

Release Notes - Version 0.13.0

Features

• Enhanced executemany() Support for Complex Data Types (#245, #260)

_What changed:_ Added full support for UNIQUEIDENTIFIER and DATETIMEOFFSET in batch operations with proper type inference and NULL handling _Who benefits:_ Applications performing bulk inserts with UUIDs and timezone-aware datetime values _Impact:_ Seamless batch operations with complex data types, improving performance for bulk data processing

• Streaming Support in executemany() (#251)

_What changed:_ Implemented robust handling of large values (NVARCHAR/VARCHAR/VARBINARY(MAX)) with automatic Data-At-Execution (DAE) detection and fallback _Who benefits:_ Applications working with large text or binary data in batch operations _Impact:_ Efficient streaming inserts and fetches for massive datasets without memory constraints

Improvements

• Enhanced Cursor Reliability (#263)

_What changed:_ Improved consistency and correctness of cursor.rowcount attribute across fetchone(), fetchmany(), and fetchall() operations, including empty result sets _Who benefits:_ Applications relying on accurate row count information for business logic _Impact:_ More reliable rowcount reporting for all cursor operations and fetch scenarios

Bug Fixes

• Type Inference Bug Fix (#252)

_What changed:_ Resolved type inference issues in executemany() by refactoring sample value selection logic _Who benefits:_ Applications using executemany() with diverse data types _Impact:_ More accurate automatic type detection in batch operations

• Memory Leak and Security Fix (#264)

_What changed:_ Replaced static token buffer with stack-allocated buffer to prevent memory leaks and ensure sensitive data is securely erased after use _Who benefits:_ Security-conscious applications and long-running services _Impact:_ Improved memory management and enhanced security for sensitive connection data

• Resource Cleanup on Python Shutdown (#255)

_What changed:_ Added proper cleanup mechanisms to prevent segmentation faults during Python interpreter shutdown _Who benefits:_ All applications, especially those with complex shutdown sequences _Impact:_ Enhanced stability and elimination of shutdown-related crashes

Infrastructure

• Testing Enhancements (#245, #260, #251, #263)

_What changed:_ Added comprehensive test coverage for UUID/GUID, DATETIMEOFFSET, streaming operations, and cursor.rowcount behavior _Who benefits:_ Contributors and maintainers _Impact:_ Improved code quality assurance and regression prevention

This release focuses on enhancing batch operation capabilities with complex data types and streaming support, while addressing critical stability and security issues to ensure robust production deployments.