How to add to an existing value using UPDATE?

[Guoyuer]

Is there any way to write SQL like this? update(table)..write() seems not proper

update products
set quantity = quantity +3```

[simolus3]

Sure:

update(table).write(YourTableCompanion.custom(quantity: table.quantity + const Constant<int>(3)));

[Guoyuer]

Sure:

update(table).write(YourTableCompanion.custom(quantity: table.quantity + const Constant<int>(3)));

Great!