microsoft/mssql-python v0.11.0-preview

v0.11.0-preview

Repository: microsoft/mssql-python

Tag: v0.11.0-preview

Published: 2025-09-19T06:18:33Z

Prerelease: yes

Release notes:

Release Notes - Version 0.11.0

Features

• Database Metadata & Catalog APIs (#201, #192)

_What changed:_ Added comprehensive getInfo() method for database information retrieval and extensive metadata APIs including getTypeInfo(), procedures(), foreignKeys(), primaryKeys(), columns(), statistics(), rowIdColumns() and, rowVerColumns(). _Who benefits:_ Developers building database introspection tools and applications requiring schema discovery _Impact:_ Complete database metadata access and improved schema management capabilities

• Advanced Parameter Management (#192)

_What changed:_ Implemented setinputsizes() method with SQL type constants export and enhanced parameter validation through the SQLTypes class _Who benefits:_ Applications requiring precise parameter type control and validation _Impact:_ Better performance and type safety in parameterized queries

• Connection-Level Execute & BatchExecute (#189)

_What changed:_ Added execute() & batchexecute() method directly to Connection class for simplified & faster query execution _Who benefits:_ Developers seeking streamlined database operations without explicit cursor management _Impact:_ More convenient & fast API for simple query operations

• Output Data Conversion System (#190)

_What changed:_ Introduced flexible output converter system with add_output_converter(), get_output_converter(), remove_output_converter(), and clear_output_converters() methods _Who benefits:_ Applications requiring custom data type transformations during result fetching _Impact:_ Customizable data processing pipeline for specialized use cases

• Global Configuration APIs (#188, #187)

_What changed:_ Added getDecimalSeperator(), setDecimalSeperator() global functions and lowercase support for global variables _Who benefits:_ Applications requiring locale-specific decimal formatting and configuration management _Impact:_ Enhanced internationalization and global configuration control

• Connection Timeout Control & Searchescape (#191)

_What changed:_ Added timeout & searchescape attribute for connection-level timeout & escape management _Who benefits:_ Applications requiring fine-grained connection timeout & escaping control _Impact:_ Better connection reliability and timeout handling

Improvements

• Large Binary Data Streaming (#232, #231)

_What changed:_ Enhanced VARBINARY(MAX) streaming support in all fetch operations with improved chunked retrieval and LOB handling _Who benefits:_ Applications processing large binary objects like images, documents, and media files _Impact:_ Efficient memory usage and reliable handling of large binary data

• Money Data Type Support (#230)

_What changed:_ Added comprehensive support for SQL Server MONEY and SMALLMONEY types with proper boundary value handling and decimal conversion _Who benefits:_ Financial applications requiring precise monetary calculations _Impact:_ Native support for SQL Server financial data types with accurate precision

• VARCHAR(MAX) Fetch Streaming (#219)

_What changed:_ Implemented streaming support for large text columns in fetchone() operations _Who benefits:_ Applications handling large text content exceeding standard buffer limits _Impact:_ Improved memory efficiency for large text data retrieval

Bug Fixes

• Parameter Type Inference (#215)

_What changed:_ Improved parameter type inference for batch operations with accurate integer range-based type selection _Who benefits:_ Applications using executemany with varied data ranges _Impact:_ More accurate SQL type mapping and better performance in batch operations

This release significantly enhances database introspection capabilities, streaming performance for large data, and provides comprehensive metadata access while maintaining backward compatibility.