René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Bulkcopy: Cannot cast Row object as tuple","articleBody":"### List of Rows from cursor.fetchall() cannot be used directly in bulkcopy\n\nData retrieved using `cursor.fetchall()` is of type `List[Row]`. Intuitively I would expect to be able to use these objects directly in `cursor.bulkcopy()`, but I get an exception.\n\n```\n  File \"/home/vscode/.local/lib/python3.14/site-packages/mssql_python/cursor.py\", line 2706, in bulkcopy\n    raise type(e)(str(e)) from None\nValueError: Expected tuple, got: 'Row' object cannot be cast as 'tuple'\n```\n\n### To reproduce\n\n```python\nimport mssql_python\n\nconn = mssql_python.connect(\"...\")\ncursor = conn.cursor()\n\ncursor.execute(f\"SELECT TOP 10 * FROM table_A\")\ndata = cursor.fetchall()\ncopy_result = cursor.bulkcopy(\"table_B\", data)\n\nconn.close()\n```\n\n(This is a simplified example - in reality I stumpled on this while trying to migrate data between two databases on different servers).\n\n### Expected behavior\nI expected the `bulkcopy` method to accept a data argument of type `List[Row]`.\n\n### Further technical details\nPython version: 3.14\nSQL Server version: Microsoft SQL Azure 12.0.2000.8\nOperating system: Linux 39a7e4bda3b8 6.6.87.2-microsoft-standard-WSL2 #1 SMP PREEMPT_DYNAMIC Thu Jun  5 18:30:46 UTC 2025 x86_64 GNU/Linux","author":{"url":"https://github.com/ebj-jyskebank-dk","@type":"Person","name":"ebj-jyskebank-dk"},"datePublished":"2026-03-23T08:11:05.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/482/mssql-python/issues/482"}