denisenkom / pytds

Python DBAPI driver for MSSQL using pure Python TDS (Tabular Data Stream) protocol implementation
MIT License
190 stars 52 forks source link

Things to document / Compat with pyodbc #133

Open aersam opened 2 years ago

aersam commented 2 years ago

Hi there Thanks for this great library! I did use it in a project where I used pyodbc before and there are some non-obvious things I think you should document. I must say however that I am relatively new to python database related stuff.

At first pyodbc has some nice extensions to the DB API I think you should consider, mostly this one: https://github.com/mkleehammer/pyodbc/wiki/Features-beyond-the-DB-API#passing-parameters

The second thing is that only the %s Parameter Syntax seems to work though the DB API mentions some more syntax types. I think you should document what you support here.