Small. Fast. Reliable.
Choose any three.

update-stmt

WITH RECURSIVE common-table-expression , UPDATE OR ROLLBACK qualified-table-name OR REPLACE OR IGNORE OR FAIL OR ABORT SET column-name-list = expr column-name , FROM table-or-subquery , join-clause WHERE expr returning-clause

Used by:   create-trigger-stmt   sql-stmt

References:   column-name-list   common-table-expression   expr   join-clause   qualified-table-name   returning-clause   table-or-subquery

See also:   lang_createtrigger.html   lang_update.html