I ported my application from mysql to postgresql. In doing so camel cased column names where changed to use an underscore as the word separator in most cases. There are a couple where the camel case was just removed.
I now need to insert to both of these databases. The data, the number of columns etc are the same just the column names are slightly different. I can use PDO to switch database drivers and insert, but id like to do this without writing two seperate sql statements for inserts. Is there a common way to map column names to array keys or populate some class and pass that to PDO.