How can I perform advanced queries using TypeORM?

How can I perform advanced queries using TypeORM?

You can use TypeORM's QueryBuilder for advanced queries. It allows you to build complex SQL queries programmatically.

Can you give me an example of using QueryBuilder for a join?

Sure! Here's a basic example: const users = await connection.getRepository(User) .createQueryBuilder('user') .leftJoinAndSelect('user.profile', 'profile') .where('user.age > :age', { age: 18 }) .getMany(); This retrieves users older than 18 along with their profiles.

What if I want to filter results based on multiple conditions?

You can chain multiple where conditions. For example: .where('user.age > :age', { age: 18 }) .andWhere('profile.isActive = :isActive', { isActive: true }).

Is it possible to use raw SQL queries in TypeORM?

Yes, you can use the query method on the connection to execute raw SQL. For example: await connection.query('SELECT * FROM users WHERE age > ?', [18]);.