Python and Databases - BKJackson/BKJackson_Wiki GitHub Wiki

How To Load Multiple Files Into Your Database With Python And SQL
Dynamically Bulk Inserting CSV Data Into A SQL Server Table - 10 minute video, covers dynamic SQL

PYODBC

pyodbc is an open source Python module that makes accessing ODBC databases simple. It implements the DB API 2.0 specification but is packed with even more Pythonic convenience.
pyodbc GitHub