Raymond, the variable substitution is normally done by the database and not the Python database modules, so you'd have to ask the database maintainers for assistance.

The qmark ('?') parameter style is part of the ODBC standard, so it's unlikely that this will get changed any time soon unless you have good contacts with Microsoft :-)

The ODBC standard also doesn't support multi-value substitutions in the API, so there's no way to pass the array to the database driver.

BTW: Such things are better discussed on the DB-SIG mailing list than the Python tracker.