How can we perform a SELECT query using a RIGHT JOIN in TypeORM?

edit

To perform a SELECT query using a RIGHT JOIN in TypeORM, we can use the following syntax:

const result = await getConnection()
    .createQueryBuilder()
    .select([
        'users.id',
        'users.name',
        'addresses.address'
    ])
    .from(User, 'users')
    .rightJoin(Address, 'addresses', 'addresses.userId = users.id')
    .where('users.id = :userId', { userId: 1 })
    .getRawMany();

In this example, we are selecting the id, name, and address fields from the users and addresses tables. We are also performing a right join between the two tables on the userId field. Finally, we are filtering the results to only return the row with id equal to 1. The getRawMany() method returns an array of raw database results.