microsoft/mssql-python v0.12.0-preview

on GitHub

Release Notes - Version 0.12.0

Features

• Complex Data Type Support (#243, #236, #241, #213)

  What changed: Added native support for DATETIMEOFFSET and UNIQUEIDENTIFIER data types with full round-trip handling
  Who benefits: Applications working with timezone-aware dates and UUID-based identifiers
  Impact: Seamless integration with Python's datetime (timezone-aware) and uuid.UUID objects

• Enhanced Financial Data Operations (#246)

  What changed: Extended MONEY and SMALLMONEY support to executemany operations with proper NULL handling and decimal conversion
  Who benefits: Financial applications using batch operations for monetary data
  Impact: Improved performance and reliability for bulk financial data processing

• Comprehensive Code Coverage Integration (#238)

  What changed: Implemented unified Python and C++ code coverage reporting with automated build instrumentation and pipeline integration
  Who benefits: Development teams and maintainers ensuring code quality
  Impact: Enhanced testing visibility and quality assurance across the entire codebase

Improvements

• Enhanced Database Metadata API (#249)

  What changed: Refactored getinfo() API with improved ODBC metadata retrieval, consistent type handling, and expanded constant exposure
  Who benefits: Applications requiring detailed database and driver metadata
  Impact: More reliable and comprehensive access to database information with better error handling

Bug Fixes

• DateTime Parsing Optimization (#235)

  What changed: Removed aggressive datetime parsing to prevent incorrect type conversions and improve data integrity
  Who benefits: Applications handling diverse datetime formats and string data
  Impact: More accurate data type handling and reduced unexpected parsing behavior

  Thanks to @arvis108 for this contribution!

Infrastructure

• Development Workflow Enhancements (#259, #238)

  What changed: Added CodeQL analysis integration and optimized PR automation with improved labeling and coverage reporting
  Who benefits: Contributors and maintainers
  Impact: Enhanced security analysis and streamlined development processes

This release focuses on expanding complex data type support, improving financial data operations, and strengthening development infrastructure while maintaining backward compatibility.