FEAT: Adding setinputsizes by jahnvi480 · Pull Request #192 · microsoft/mssql-python

@jahnvi480

### Work Item / Issue Reference  
<!-- 
IMPORTANT: Please follow the PR template guidelines below.
For mssql-python maintainers: Insert your ADO Work Item ID below (e.g.
AB#37452)
For external contributors: Insert Github Issue number below (e.g. #149)
Only one reference is required - either GitHub issue OR ADO Work Item.
-->

<!-- mssql-python maintainers: ADO Work Item -->
>
[AB#34934](https://sqlclientdrivers.visualstudio.com/c6d89619-62de-46a0-8b46-70b92a84d85e/_workitems/edit/34934)

-------------------------------------------------------------------
### Summary   
This pull request adds support for retrieving ODBC data type information
via a new `getTypeInfo` method on the `cursor` object, exposing the
underlying `SQLGetTypeInfo` API. It includes the necessary C++/Python
bindings, error handling, and comprehensive test coverage to ensure
correct behavior for different data types and usage scenarios.

### Feature: Data type information retrieval

* Added a new `getTypeInfo` method to the `cursor` class in
`mssql_python/cursor.py`, allowing users to retrieve metadata about
supported SQL data types via the ODBC `SQLGetTypeInfo` API. The method
supports querying all types or a specific type and returns results as a
list of `Row` objects with a well-defined column map.

### Bindings and driver integration

* Introduced a new function pointer type for `SQLGetTypeInfo`
(`SQLGetTypeInfoFunc`) and integrated it into the driver loading and
verification process in `mssql_python/pybind/ddbc_bindings.h` and
`mssql_python/pybind/ddbc_bindings.cpp`. This ensures the function
pointer is loaded and checked along with other ODBC APIs.
* Added a wrapper function and Python binding for `SQLGetTypeInfo`,
exposing it as `DDBCSQLGetTypeInfo` in the Python module.

### Testing

* Added a comprehensive suite of tests in `tests/test_004_cursor.py` to
validate the new `getTypeInfo` method. Tests cover retrieving all types,
specific types, result structure, numeric and datetime types, binary
types, multiple successive calls, and repeated identical queries for
consistency and efficiency.

---------

Co-authored-by: Jahnvi Thakkar <jathakkar@microsoft.com>