Installation with poetry and mssqlserver extra broken

[tharwan]

Hi,

when installing with the mssqlserver extra poetry attempts to install pymssql 3.0.3 which complains:

DeprecationWarning: The pymssql project has been discontinued. To install the last working released version, use a
version specifier like "pymssql<3.0". For details and alternatives see:
pymssql/pymssql#668
[end of output]

a workaround is to do as it says. But maybe the pymssql dependency should be removed in favour of pyodbc.

[Warfront1]

pymssql is still fully supported and maintained, read the whole chain.
Compared to similar official Microsoft SQL Github repositories, in my opinion, the support/maintenance of pymssql would appear to be better than that of Microsoft's.

[tharwan]

Well it is nice to know but not obvious at all given the error message and the linked ticket 😅