Solving Pandas .to_sql Double Quotes Issue When Writing to Database

I have found a solution to the frustrating issue of using pandas to save a dataframe into a database and finding that the column names are encased in double quotes.

By setting the column names to uppercase before writing the dataframe to the database, the double quotes problem can be completely circumvented.

df.columns.str.upper()

When creating the table structure in the database, please ensure that your column names are in uppercase.

CREATE TABLE table_name
(
    COLUMN1     VARCHAR2(50),
    COLUMN2     VARCHAR2(50),
    COLUMN3     Integer
);