ADO Work Item Reference

AB#37935

Summary

This pull request introduces significant updates to theexecutemany method in themssql_python library to enable column-wise parameter binding for batched SQL execution. It also includes enhancements to the underlying C++ bindings to support this functionality. The most important changes involve implementing column-wise binding logic, adding helper functions for parameter buffer allocation, and exposing a newSQLExecuteMany method for executing batched statements.

Enhancements to Pythonexecutemany method:

• mssql_python/cursor.py: Refactored theexecutemany method to use column-wise parameter binding for improved performance and scalability. Added_transpose_rowwise_to_columnwise helper function to convert row-wise parameters into column-wise format.

Updates to C++ bindings:

• mssql_python/pybind/ddbc_bindings.cpp: AddedBindParameterArray function to handle column-wise parameter binding, supporting multiple data types such asSQL_C_LONG,SQL_C_DOUBLE, andSQL_C_WCHAR.
• mssql_python/pybind/ddbc_bindings.cpp: IntroducedSQLExecuteMany_wrap function to enable batched execution of SQL statements with multiple parameter sets.
• mssql_python/pybind/ddbc_bindings.cpp: Exposed the newSQLExecuteMany method to Python viaPYBIND11_MODULE.

Helper functions for buffer allocation:

• mssql_python/pybind/ddbc_bindings.cpp: AddedAllocateParamBufferArray template function to allocate buffers for column-wise parameter binding.