printf "insert into %s (%s) values (%s) on duplicate key update %s=values(%s),%s=values(%s)",
            $dbh->quote_identifier(
                $tablename
            ),
            join(
                ',',
                map { $dbh->quote_identifier($_) } @columns
            ),
            join( ',', ('?') x @columns ), ????