RuntimeError: MsSQL failed to get the columns of query: waitfor delay '00:00:01'

[NoEdgeAtLife]

What language are you using?

Python

What version are you using?

3.11

What database are you using?

MsSQL

What dataframe are you using?

Arrow

What are the steps to reproduce the behavior?

Example query / code

import connectorx as cx
conn = 'mssql://'         # connection token
query = """waitfor delay '00:00:01'"""
result = cx.read_sql(conn, query, return_type="arrow")          

What is the error?

Traceback (most recent call last):
  File ".\connector_x.py", line 10, in <module>
    result = cx.read_sql(conn, query, return_type="arrow")  
  File ".venv\lib\site-packages\connectorx\__init__.py", line 257, in read_sql
    result = _read_sql(
RuntimeError: MsSQL failed to get the columns of query: waitfor delay '00:00:01'