Support usage of update clause in non-MySQL DBs

It would be useful to people to be able to use `update` for DBs that are not MySQL. To handle it, a trigger will have to be made against the table to run on row update. The devil in the details here is to properly deal with the trigger on column rename / update / deletion.

From #1800 and #1798 