Can't update entity that has a composite FK as part of its PK

[erik-induro]

Describe the bug
I have an entity whose primary key includes a composite foreign key. I can't update it. The generated sql appears to be wrong. This is a pretty common scenario for me since I am using partitioned tables.

Stack trace
N/A - there is no error but here is the generated (formatted) query:

update "site"
set "name" = 'Site 2'
where ("program_id", "program_organization_id") in (
  select "e0"."id", "e0"."program_id"
  from (
    select distinct "e0"."id", "e0"."program_id"
    from "site" as "e0"
    left join "program" as "e1"
      on "e0"."program_id" = "e1"."id"
      and "e0"."program_organization_id" = "e1"."organization_id"
    where "e0"."id" = '7007a128-4cc0-4177-b754-0cda0927368d'
      and "e1"."id" = 'cc455d1f-f4c7-4b57-b833-e6ca88239b61'
      and "e1"."organization_id" = 'e3dca7ae-6389-49dc-931d-419716828a79'
  ) as "e0"
)

As you can see, the where is looking for "program_id", "program_organization_id" but the inner select returns "site_id", "program_id" (I translated them). So it never matches and updates 0 rows.

To Reproduce
I updated my previous example here with a new test:
https://github.com/erik-induro/mikro-orm-fk

Expected behavior
The entity should be updated.

Additional context
N/A

Versions

Dependency	Version
node	14.15.3
typescript	4.2.3
mikro-orm	4.5.2
@mikro-orm/postgresql	4.5.2