The code actually does the right thing (INSERT for new objects, UPDATE for existing). Since the SQL is automatically generated (and since DBI doesn't let you see the actual SQL that goes through to the DB (unless you want an awful lot of debugging information as well), I just typed them in off the top of my head.

The top of my head needs a bit of work :-)

Anyway, the SQL statements generated are syntacticly correct, except when a quoted date comes into the arena :-)

I can't use the suggestion you offer unfortunately, because all SQL is generated on the fly, based on configuration data.

Without looking at each component of each INSERT/UPDATE, I don't know which ones I have to treat 'specially', and which ones I can use placeholders for.