# Write SQL Your Way: Dual Parameter Style Benefits in mssql-python

DevFeed: [Write SQL Your Way: Dual Parameter Style Benefits in mssql-python](<https://devfeed.tech/articles/write-sql-your-way-dual-parameter-style-benefits-in-mssql-python-20356.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/python/write-sql-your-way-dual-parameter-style-benefits-in-mssql-python/>)

Author: Jahnvi Thakkar

Published: 2026-04-07T16:12:05Z

Content type: article

Language: en

Sources: [Microsoft Python Engineering](<https://devfeed.tech/sources/microsoft-python-engineering.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Python](<https://devfeed.tech/topics/python.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Microsoft](<https://devfeed.tech/topics/microsoft.md>), [Azure](<https://devfeed.tech/topics/azure.md>)

Tags: [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [client-driver](<https://devfeed.tech/tags/client-driver.md>), [code](<https://devfeed.tech/tags/code.md>), [developers](<https://devfeed.tech/tags/developers.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [python](<https://devfeed.tech/tags/python.md>), [python-driver-for-azure-sql](<https://devfeed.tech/tags/python-driver-for-azure-sql.md>), [python-driver-for-sql-server](<https://devfeed.tech/tags/python-driver-for-sql-server.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>)

## AI overview

Microsoft's mssql-python driver now supports both qmark positional parameters and pyformat named parameters for Python applications using SQL Server and Azure SQL. The driver automatically detects the parameter style from the supplied tuple, list, or dictionary, while preserving existing qmark code without configuration changes.

## Source excerpt

Reviewed by: Sumit Sarabhai If you've been writing SQL in Python, you already know the debate: positional parameters (?) or named parameters (%(name)s)? Some developers swear by the conciseness of positional. Others prefer the clarity of named. With mssql-python, you no longer need to choose - we support both. We've added dual parameter style support to mssql-python, enabling both qmark and pyformat parameter styles in Python [...] The post Write SQL Your Way: Dual Parameter Style Benefits in mssql-python appeared first on Microsoft for Python Developers Blog.