Blog Post

SQL Server Blog
2 MIN READ

Announcing mssql-python 1.18.0: Faster fetch paths, smarter reuse, stronger reliability

DavidLevy's avatar
DavidLevy
Icon for Microsoft rankMicrosoft
Nov 19, 2026

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

Published Nov 19, 2026
Version 1.0
No CommentsBe the first to comment