Great post :)
I used to use pyodbc from beginning but unfortunately it didn't work on heroku so I shifted to pymssql .

Perhaps, best way is to use both Beem and HiveSQL.

This is true. I sometimes use been API , HiveSQL as well as hiveengine API to make it effective.

Posted Using LeoFinance ^Beta