SQL query for merged results

[michael1978]

Hey! 

Is there any way to see the sql query for merged results like it is seen for regular queries?

If not then maybe can someone help me understand the merge logic and how to replicate it in a query?

The combining merge values are:
public.items  AS items ON vendor_integrations.items_uuid = items.uuid
public.items  AS items ON (client_integration_groups.items_uuid::uuid) = (items."uuid")


Thanks!