With this class you can query your databases using 3 lines of code. It's based on SQLAlchemy and seamlessly handles SQL Server Port Forwarding and SSH Tunnel creation for you. It converts SQL query results to pandas dataframes.
query = "SELECT * FROM table;"
with Connection("ENV_NAME") as conn:
query_results = conn.get_dataframe(query)