Wrapping a query with the "$and" operator causes a invalid query

[merceyz]

Describe the bug

Wrapping a find query with the $and operator causes it to query the wrong table+column

Stack trace

InvalidFieldNameException: select `e0`.*, `e1`.`id` as `user_id` from `profile` as `e0` left join `user` as `e1` on `e0`.`id` = `e1`.`profile_id` where `e0`.`user_id` in (123) - SQLITE_ERROR: no such column: e0.user_id
    at SqliteExceptionConverter.convertException (C:\testcase\.yarn\$$virtual\@mikro-orm-sqlite-virtual-4d94b4ca8a\0\cache\@mikro-orm-sqlite-npm-4.0.3-6abbc1e0ec-39975ba0c2.zip\node_modules\@mikro-orm\sqlite\SqliteExceptionConverter.js:32:20)
    at SqliteDriver.convertException (C:\testcase\.yarn\$$virtual\@mikro-orm-core-virtual-6c2ac32c4b\0\cache\@mikro-orm-core-npm-4.0.3-4ae154529f-9ed736faf4.zip\node_modules\@mikro-orm\core\drivers\DatabaseDriver.js:168:54)
    at C:\testcase\.yarn\$$virtual\@mikro-orm-core-virtual-6c2ac32c4b\0\cache\@mikro-orm-core-npm-4.0.3-4ae154529f-9ed736faf4.zip\node_modules\@mikro-orm\core\drivers\DatabaseDriver.js:172:24
    at SqliteDriver.find (C:\testcase\.yarn\$$virtual\@mikro-orm-knex-virtual-5180ec5ee4\0\cache\@mikro-orm-knex-npm-4.0.3-43ff3bffe1-ed619bd1a1.zip\node_modules\@mikro-orm\knex\AbstractSqlDriver.js:42:24)
    at SqlEntityManager.find (C:\testcase\.yarn\$$virtual\@mikro-orm-core-virtual-6c2ac32c4b\0\cache\@mikro-orm-core-npm-4.0.3-4ae154529f-9ed736faf4.zip\node_modules\@mikro-orm\core\EntityManager.js:75:25)
    at C:\testcase\index.ts:24:2

To Reproduce

// User.ts
import { Entity, PrimaryKey, OneToOne } from '@mikro-orm/core';
import { Profile } from './Profile';

@Entity()
export class User {
	@PrimaryKey()
	id: number;

	@OneToOne(() => Profile)
	profile: Profile;
}

// Profile.ts
import { Entity, PrimaryKey, OneToOne } from '@mikro-orm/core';
import { User } from './User';

@Entity()
export class Profile {
	@PrimaryKey()
	id: number;

	@OneToOne(() => User, (user) => user.profile)
	user: User;
}

// index.ts
import { MikroORM } from '@mikro-orm/core';
import { Profile } from './Profile';
import { User } from './User';

(async () => {
	const orm = await MikroORM.init({
		type: 'sqlite',
		dbName: ':memory:',
		debug: true,
		entities: [User, Profile],
	});

	await orm.getSchemaGenerator().ensureDatabase();
	await orm.getSchemaGenerator().createSchema();

	const user = new User();
	user.id = 123;
	user.profile = new Profile();
	user.profile.id = 456;
	await orm.em.persist(user).flush();
	orm.em.clear();

	// OK
	await orm.em.getRepository(Profile).find({ user: { id: [123] } });
	// Error
	await orm.em.getRepository(Profile).find({ $and: [{ user: { id: [123] } }] });
})();

Expected behavior

Wrapping the query in $and should not cause it to fail

Versions

Dependency	Version
node	12.18.3
typescript	4.0.2
@mikro-orm/core	4.0.3
@mikro-orm/sqlite	4.0.3
@mikro-orm/mysql	4.0.3

[B4nan]

This works fine btw:

await orm.em.getRepository(Profile).find({ $and: [{ user: { id: { $in: [123] } } }] });

[B4nan]

So looks like that query I suggested above "works", but it is actually also wrong (searches by the inverse side PK instead)...