[BUG]: Entity alias is not being escaped/quoted when used in the where option using EntityManager find() method

[fendy-bubbler]

Issue description

Entity alias is not being escaped/quoted when used in the where option using EntityManager find() method. This causes issue when the alias hash starts with a number and it's not a valid identifier without double quotes in PostgreSQL

Expected Behavior

The query generated should quote the table aliases to avoid hashes that has number in front.

SELECT 
...
(SELECT name FROM "teacher" WHERE "teacher".id= "student".teacher_id) AS COL_A
FROM student
WHERE
  (SELECT name FROM "teacher" WHERE "teacher".id= "student".teacher_id) = 'patrick'

Actual Behavior

Aliases are not quoted when used in where clause

SELECT 
...
(SELECT name FROM "teacher" WHERE "teacher".id= "student".teacher_id) AS COL_A
FROM student
WHERE
  (SELECT name FROM "teacher" WHERE "teacher".id= student.teacher_id) = 'patrick'

Steps to reproduce

1. Has a VirtualColumn in an Entity
2. Has the SQL for the column to use alias in where clause or as table

@VirtualColumn({
    query: (alias) =>
      `
        SELECT name FROM "teacher" WHERE "teacher".id= ${alias}.teacher_id
      `,
  })
  teacherName?: string;

4. Use find() with 'where` option

studentRepo.find({
    where: {
       teacherName: 'patrick',
    },
  });

My Environment

Dependency	Version
Operating System	MacOS 13.1
Node.js version	v16.15.0
Typescript version	7.17.12
TypeORM version	0.3.11

Additional Context

No response

Relevant Database Driver(s)

• aurora-mysql
• aurora-postgres
• better-sqlite3
• cockroachdb
• cordova
• expo
• mongodb
• mysql
• nativescript
• oracle
• postgres
• react-native
• sap
• spanner
• sqlite
• sqlite-abstract
• sqljs
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

Yes, I have the time, but I don't know how to start. I would need guidance.