Enable Bulk Copy Support

[perrysk-msft]

Is your feature request related to a problem? Please describe.

Bulk copy operations (similar to bcp or SqlBulkCopy in .NET) are essential for efficiently inserting large datasets into SQL Server. Supporting this feature in mssql-python would significantly improve performance for data ingestion workflows.
-Performance: Bulk copy reduces the overhead of multiple insert statements, improving data load speed.
-Use Cases: Ideal for ETL processes, large-scale data migrations, and batch inserts.
-Existing Support in Other Drivers: Many database drivers offer bulk insert capabilities, making this a valuable addition.

Describe the solution you'd like

Expose a bulk insert API in mssql-python, allowing users to insert data efficiently.
Example from cTDS: https://zillow.github.io/ctds/bulk_insert.html

[eavanvalkenburg]

Since this is a python driver, please consider not making this a separate api, but just allow and deal with, single, list and AsyncIterable through a single method!

[amachanic]

Since this is a python driver, please consider not making this a separate api, but just allow and deal with, single, list and AsyncIterable through a single method!

You really don't want to put single rows through the bulk copy API - it's much, much slower than an insert in that case. At some point as the row count increases the efficiency of scale improves. I think the correct interface here is Iterable, which will support lists, tuples, generators, etc.

[eavanvalkenburg]

My thinking is that the python side can deal with anything, and then based on the type or the number of records, it decides what to use towards the actual DB