I use python with SQL Server extensively. In fact, I have written about it before at https://www.simple-talk.com/sql/database-administration/python-for-the-sql-server-dba/ and I have used in in some of the examples for articles I have written here.

I primarily use pyodbc to interface SQL Server and my Python code, but that is not the only option out there.