executemany regular-expression and deprecated VALUES()

[srepmub]

regarding executemany. according to the mysql docs, one should use an alias 'as blah' on VALUES, which can then be used like 'ON DUPLICATE KEY UPDATE col=blah.col'.. but the regular expression in cursors.py doesn't match with the alias part.. so for performance, we cannot move off the deprecated 'col=VALUES(col)' syntax.

[methane]

please don't use executemany(). build your own query builder isntead.