Pandas version checks
-
[X] I have checked that this issue has not already been reported.
-
[X] I have confirmed this bug exists on the latest version of pandas.
-
[x] I have confirmed this bug exists on the main branch of pandas.
Reproducible Example
polars as pl
query = "SELECT getdate(), t.* FROM table "
df_sql = pl.read_sql(query, conn_uri_db1)`
df_sql.schema
df_sql.to_pandas(use_pyarrow_extension_array=True).to_sql('table_name', conn_uri_db2, if_exists='replace')
>Error message: 'ArrowExtensionArray' object has no attribute 'to_pydatetime'```
Issue Description
Hi everyone. I was trying to take data from one database and write it into another, using Polars, but I was getting this error, analyzing the trace it occurs when polars uses pandas behind the scene to convert their dataframe to pandas dataframe and use the to_sql command, so I reproduced what polars does. Apparently the error only occurs when using a dataframe that has datetime columns. Thanks in advance for your help.
Here is the full trace error:
``` AttributeError Traceback (most recent call last)
~\AppData\Local\Temp\ipykernel_14916\424779397.py in
~\Anaconda3\lib\site-packages\pandas\core\generic.py in to_sql(self, name, con, schema, if_exists, index, index_label, chunksize, dtype, method) 2985 from pandas.io import sql 2986 -> 2987 return sql.to_sql( 2988 self, 2989 name,
~\Anaconda3\lib\site-packages\pandas\io\sql.py in to_sql(frame, name, con, schema, if_exists, index, index_label, chunksize, dtype, method, engine, **engine_kwargs) 693 ) 694 --> 695 return pandas_sql.to_sql( 696 frame, 697 name,
~\Anaconda3\lib\site-packages\pandas\io\sql.py in to_sql(self, frame, name, if_exists, index, index_label, schema, chunksize, dtype, method, engine, **engine_kwargs) 1736 ) 1737 -> 1738 total_inserted = sql_engine.insert_records( 1739 table=table, 1740 con=self.connectable,
~\Anaconda3\lib\site-packages\pandas\io\sql.py in insert_records(self, table, con, frame, name, index, schema, chunksize, method, **engine_kwargs) 1323 1324 try: -> 1325 return table.insert(chunksize=chunksize, method=method) 1326 except exc.SQLAlchemyError as err: 1327 # GH34431
~\Anaconda3\lib\site-packages\pandas\io\sql.py in insert(self, chunksize, method)
922 raise ValueError(f"Invalid parameter method: {method}")
923
--> 924 keys, data_list = self.insert_data()
925
926 nrows = len(self.frame)
~\Anaconda3\lib\site-packages\pandas\io\sql.py in insert_data(self) 890 vals = ser._values 891 if vals.dtype.kind == "M": --> 892 d = vals.to_pydatetime() 893 elif vals.dtype.kind == "m": 894 # store as integers, see GH#6921, GH#7076
AttributeError: 'ArrowExtensionArray' object has no attribute 'to_pydatetime' ```
Expected Behavior
I expect to be able to write columns with datetime type into my database.