+1 on this union() feature; it really could be a game changer (especially on roadmap/PM topics) to merge same entity type in a single place even when feeded from several sources.
Automation can be used as workaround, but it requires to limit/restrict the way to use it to a strict workflow (e.g. relations between entities to be set in a certain order) that may not be always be followed.