title: How to insert datetime using sqlalchemy?
body: <p>I have this code to insert into SQLITE some rows, using alchemy :</p>
  
  <pre><code> df['date_create'] = pd.to_datetime(df['date_create'])
  
   list1 = df.to_dict(orient='records') 
   list1= list1[0]
   metadata = sql.schema.MetaData(bind=dbengine,reflect=True)
   table = sql.Table(table1, metadata, autoload=True)
  
   Session = sql.orm.session.sessionmaker(bind=dbengine)
   session = Session()
   res= dbengine.execute(table.insert(), list1)
  </code></pre>
  
  <p>But, I got this error message:</p>
  
  <pre><code>(exceptions.TypeError) SQLite DateTime type only accepts 
  Python datetime and date objects as input. 
  </code></pre>
  
  <p>How to pass datetime for insertion ?</p>