in reply to DBIx::Class update and simultaneosly modify field

DBIx::Class will pass scalar refs as literal SQL, so you can do this...

$rs->find_or_create({ field1 => 55 })->update({ field2 => \'field2+1' });

We're not surrounded, we're in a target-rich environment!