Skip to content

Add Arrow support for new mssql-python driver in read_database #30195

Open

Description

@vladidobro

Description

Hi,

there is a new driver developed by Microsoft mssql-python
that supports fetching from the cursor in Apache Arrow format.
Recent SQLAlchemy 2.1 release added support for the mssql-python driver (mssql+mssqlpython:// url).

polars.read_database already has support for SQLAlchemy drivers that support this kind of optimization,
it sniffs the driver name from the sqlalchemy.Engine object and uses the optimized Arrow methods if available,
for example for the oracle+oracledb:// driver.

It seems very natural to extend this support to the new mssql+mssqlpython:// driver.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-io-databaseArea: reading/writing to databasesenhancementNew feature or an improvement of an existing feature

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions