The UPDATE statement lacks some useful features, such as:
- table alias ("UPDATE TableA AS a")
- joins ("UPDATE TableA INNER JOIN TableB ON ... SET a.rowX=1 WHERE b.rowY=64 AND a.rowZ=1")
Are there any plans for extending UPDATE in the near future?