It would be great if the pd.to_sql function would add new columns to an existing database table when appending. This would happen when the dataframe which is to be appended to the database table ...

Right-click the table and select "Properties." The table's properties display, including the columns. You click a column and change the heading to edit the current columns.