How do I use TypeORM's Query Builder?

How do I use TypeORM's Query Builder to fetch data from my database?

You can use TypeORM's Query Builder by creating a query using the createQueryBuilder method. For example, const users = await getRepository(User).createQueryBuilder('user').getMany(); will fetch all users.

Can I add conditions to my query?

Yes, you can add conditions using the where method. For instance, createQueryBuilder('user').where('user.age > :age', { age: 18 }).getMany(); will fetch users older than 18.

What if I want to join another table?

You can use the leftJoin or innerJoin methods. For example, createQueryBuilder('user').leftJoinAndSelect('user.profile', 'profile').getMany(); will join the profile table.

Is it possible to order the results?

Absolutely! You can use the orderBy method. For example, createQueryBuilder('user').orderBy('user.name', 'ASC').getMany(); will order users by name in ascending order.