Simple use pymssql

quering_mssql.py

# -*- coding utf-8 -*-
import pymssql

SQL_SERVER = {
    'server': '127.0.0.1:1433',
    'user': 'myuser',
    'password': 'mypass',
    'database': 'mydatabase',
}

QUERY = """
  SELECT *
  FROM MYTABLE(nolock)
  WHERE COLUMN={0}
"""

def fetch_sqlserver_select(config, query):
    conn = pymssql.connect(**config)
    cursor = conn.cursor(as_dict=True)
    cursor.execute(query)
    for row in cursor:
        yield row
    cursor.close()
    conn.close()

my_rows = list(fetch_sqlserver_select(SQL_SERVER,QUERY.format("RAFAEL")))
print(rows)