如何使用typeorm查询构建器创建查询，以便从数据库中过滤数据？

import { getRepository, SelectQueryBuilder } from 'typeorm';
import { Entity } from './path/to/entity';

const repository = getRepository(Entity);

const queryBuilder = repository.createQueryBuilder('alias');

queryBuilder.select(['alias.field1', 'alias.field2']);

queryBuilder.where('alias.field = :value', { value: 'example' });

queryBuilder.andWhere('alias.field2 = :value2', { value2: 'example2' });

queryBuilder.orderBy('alias.field', 'ASC');

queryBuilder.skip(0).take(10);

const results = await queryBuilder.getMany();

const result = await queryBuilder.getOne();

const count = await queryBuilder.getCount();