$db->employees->update({ salary => $Q{salary} + $Q{salary} * $Q{merit}{percentage} }); Not that much simpler in that case, but at least lets you define t

$db->employees->update({ salary => $Q{salary} + $Q{salary} * $Q{merit}{percentage} }); Not that much simpler in that case, but at least lets you define the JOIN once rather than repeating it per-query.