Invalid SQL query for ManyToMany relations using some, none or every when querying

[NicklasKnell]

Describe the bug

Using a query operator like $some, $none or $every on a ManyToMany relation results in an invalid query, if the Entities start with the same Letter.

This error is from the provided reproduction:

select count(*) as "count"
from "user" as "u0"
where
    "u0"."id" in (
        select "u0"."id"
        from
            "user" as "u0"
            left join "user_labels" as "u1" on "u0"."id" = "u1"."user_id"
            inner join "public"."user_label" as "u1" on "u1"."user_label_id" = "u1"."id"
        where
            "u1"."user_label_id" = 1
    )

table name "u1" specified more than once

Reproduction

I used docker compose to start a postgresql instance.
https://github.com/NicklasKnell/reproduction/tree/illegal-query-for-manytomany

When renaming the Entity UserLabel to Label it will work.

What driver are you using?

@mikro-orm/postgresql

MikroORM version

6.1.5

Node.js version

v20.11.0

Operating system

Ubuntu

Validations

• Read the Contributing Guidelines.
• Read the docs.
• Check that there isn't already an issue that reports the same bug to avoid creating a duplicate.
• Check that this is a concrete bug. For Q&A open a GitHub Discussion or join our Slack.
• The provided reproduction is a minimal reproducible example of the bug.

[B4nan]

I guess I see it, we clone the QB (which resets the alias counter), but then use the original QB instance to get the next alias here.