title: sqlalchemy.exc.StatementError: (builtins.TypeError) SQLite Date type only accepts Python date objects as input
body: <p>I have pandas data frame that contains Month and Year values in a <code>yyyy-mm</code> format. I am using <code>pd.to_sql</code> to set the data type value to sent it to <code>.db</code> file.</p>
  <p>I keep getting error:
  <code>sqlalchemy.exc.StatementError: (builtins.TypeError) SQLite Date type only accepts Python date objects as input.</code></p>
  <p>Is there a way to set 'Date' Data type for 'MonthYear' (yyyy-mm) column? Or it should be set in a VARCHAR? I tried changing it to different types pandas's datetime data type, none of them seem to work.</p>
  <p>I don't have any issues with 'full_date', it assigns it properly. Data type for 'full_date' is <code>datetime64[ns]</code> in pandas.</p>
  <pre><code>MonthYear full_date
  2015-03   2012-03-11
  2015-04   2013-08-19
  2010-12   2012-06-29
  2012-01   2018-01-01
  
  
  df.to_sql('MY_TABLE', con=some_connection,
  dtype={'MonthYear':sqlalchemy.types.Date(),
         'full_date':sqlalchemy.types.Date()})
  </code></pre>