pymssql==2.3.4 in microsoft.mssql provider causes install failure on Python 3.12 (fixed in 2.3.5)

[nhutminh9799]

Apache Airflow version

3.0.2

If "Other Airflow 2 version" selected, which one?

apache-airflow-providers-microsoft-mssql==4.3.0 requires pymssql==2.3.4

What happened?

Apache Airflow Provider - Microsoft MSSQL

The current version of apache-airflow-providers-microsoft-mssql==4.3.0 requires pymssql==2.3.4, which is not compatible with Python 3.12 (e.g., on macOS ARM).

What you think should happen instead?

No response

How to reproduce

This is causing the following error during install/build:

Reference to the upstream issue in pymssql repo:
🔗 pymssql/pymssql#945

The issue has been resolved in pymssql==2.3.5, which provides support for Python 3.12 and includes prebuilt wheels for macOS ARM.

Suggested fix

Please update the dependency in the next release of apache-airflow-providers-microsoft-mssql:

pymssql>=2.3.5


### Operating System

MacOS 15.5,  Macbook Pro M4

### Versions of Apache Airflow Providers

_No response_

### Deployment

Official Apache Airflow Helm Chart

### Deployment details

_No response_

### Anything else?

_No response_

### Are you willing to submit PR?

- [ ] Yes I am willing to submit a PR!

### Code of Conduct

- [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.

[eladkal]

requires pymssql==2.3.4, which is not compatible with Python 3.12 (e.g., on macOS ARM).

The requirement is:
pymssql >=2.3.0,!=2.3.3

https://pypi.org/project/apache-airflow-providers-microsoft-mssql/4.3.0/

You can install 2.3.5 without issues.

[potiuk]

Also @nhutminh9799 -> you should have checked that updating to min 2.3.5 has been merged yesterday - #52307