This looks really interesting! I do appreciate how clunky the DB-API is, this looks like a really nice alternative.
You should consider writing a full abstract implementation so that it's easy to implement this API for new DBs, Python's abstract base classes are great. I did something similar with the DB API PEP: https://github.com/thesketh/pep249