We’re excited to announce mssql-python 1.18.0, focused on one thing you'll feel immediately: better runtime efficiency without breaking expected behavior.
This release improves repeated-query execution, single-row and batch fetch paths, row-to-dictionary conversion, and pyformat processing. It also adds custom application names for clearer telemetry and ships important reliability fixes for pooled connections and Arrow reader shutdown.
What’s new in 1.18.0
1. Faster data access and repeated execution
mssql-python 1.18.0 reduces repeated work across key hot paths:
- Reuses row-mapping metadata for faster row-to-dictionary conversion
- Optimizes single-row fetch scenarios (fetchone(), fetchmany(1), fetchval(), iterator paths)
- Improves batch fetching with output converters
- Converts pyformat placeholders in a single pass and caches converted statements
- Reuses compatible prepared statement bindings to avoid unnecessary re-prepare cycles
The result is less repeated parsing, conversion, and allocation in read-heavy or parameterized workloads.
2. Better observability with custom application names
Connection strings now support APP and Application Name. Names are propagated across sync, async, and bulk-copy paths and appear as:
MSSQL-Python|ContosoSalesApp
This makes server-side monitoring and workload attribution easier, especially in shared environments.
3. Reliability fixes
1.18.0 includes important fixes for production stability:
- Fix for Azure Synapse pooled-connection close behavior
- Correct handling of explicit pooled checkout timeouts
- Arrow reader cross-thread shutdown coordination improvements
- Correct pyformat placeholder handling in literals, identifiers, comments, and escaped %
4. Rust-backed path improvements (mssql-python-rs)
If you are using the Rust-backed paths, this release increases performance and reliability:
- Reduced SQL scan/transcode/serialization overhead
- macOS strict TLS improvements
- Table-valued parameter support in the opt-in Rust ODBC provider
- Additional timeout, lifecycle, cleanup, and streaming-order fixes
Upgrade now
pip install --upgrade mssql-python
PyPI: https://pypi.org/project/mssql-python/1.18.0/
Release notes: https://github.com/microsoft/mssql-python/releases/tag/v1.18.0