I would recommend polars.read_database_uri (https://docs.pola.rs/api/python/stable/reference/api/polars.read_database_uri.html). You can use a connectorx URI which supports MsSQL and the partition_ parameters if you want to use chunks.
polars.read_database_uri
partition_