Updating records

An SQL UPDATE statement changes the data of one or more records in a table. Either all the rows can be updated, or a subset may be chosen using a condition. ^[1]

The Update object executes declarative UPDATE statement in SQL databases, and conditions for subsets are defined by using Update::where().