Postgres allows:
UPDATE dummy
SET customer=subquery.customer,
address=subquery.address,
partn=subquery.partn
FROM (SELECT address_id, customer, address, partn
FROM /* big hairy SQL */ ...) AS subquery
WHERE dummy.address_id=subquery.address_id;
This syntax is not standard SQL
S. Eismann, L. Bui, J. Grohmann, C. Abad, N. Herbst, и S. Kounev. Proceedings of the 22nd International MIDDLEWARE Conference, стр. 248–259. (2021)Best Student Paper Award, ACM Artifacts Evaluated — Functional.
V. Lesch, T. Noack, J. Hefter, S. Kounev, и C. Krupitzer. Proceedings of the 2nd IEEE International Conference on Autonomic Computing and Self-Organizing Systems - ACSOS 2021, IEEE, (2021)Best Paper Award Runner Up, Full Paper Acceptance Ratio: 25%.
V. Lesch, M. Hadry, S. Kounev, и C. Krupitzer. Proceedings of 3rd International Workshop on Pervasive Computing for Vehicular Systems (PerVehicle), 2021, IEEE, (March 2021)