cursor.executemany rejects INSERT statements with leading whitespaces

[vhermecz]

The regex for matching insert statements assumes the query starts with INSERT. This can be a problem with multiline strings.

Example:

sql = """
  INSERT INTO table1 (col1, col2)
  VALUES (:name, :age)
"""

This guy gets rejecte due to the whitespace in front of the INSERT keyword.

Possible solutions:

• Extend RE with \s*
• Call strip() on the executemany argument