title: method = 'multi' not working on the sqlalchemy package in python
body: <p>i currently use sqlalchemy package and my installed package is 1.3.16. and my python version is 3.6.7. i am able to write small datasets to SQL server using sqlalchemy and to_sql, but when i try to write 1.1M row dataset to sql server, it takes a few hours. from my online research, i see that sqlalchemy has the optional parameter method= 'multi' option. but when i use it, i get the error, 'to_sql' has no parameter 'method'. here is my code. if i use the same code without 'method' parameter, it works but just painfully slow.</p>
  <pre><code>import sqlalchemy
  import math
  
  input_num_of_cols=len(input.columns)
  chunknum=math.floor(2000/input_num_of_cols)
  
  engine = create_engine(&quot;mssql+pyodbc://@CRSQLDEV04&quot;) 
  conn = engine.connect()
  
  input.to_sql('Input',con=conn,chunksize=chunknum, method = 'multi', if_exists = 'append', index = False, schema = 'ABC.dbo')
  </code></pre>
  <p>any idea if its the sqlalchemy package i am using? or my python version?</p>
  <p>Thanks in advance, Ramesh</p>