Notes regarding BulkInserts using SqlAlchemy
When working with Python and SqlAlchemy I found that as I got into the grove of working with it, that I was following partular patterns of actions that seemed optimum. As typical, these patterns of action were foud after iterating through many other actions and code patterns that where non-optimum, or which had no workability. So I hope your life is easier given this information.
The following code should work databases that support the static bulk load coding pattern.