有没有办法从TypeORM关系中排除字段(或包含某些字段)？

@Entity()
export class User {
  @PrimaryGeneratedColumn()
  id: number;

  @Column({ select: true })
  username: string;

  @Column({ select: false }) // 默认情况下，这个字段不会被包含
  password: string;
}

const users = await getConnection()
  .getRepository(User)
  .createQueryBuilder('user')
  .select('user.id', 'id')
  .addSelect('user.username', 'username')
  .getRawMany();

@Entity()
export class User {
  @PrimaryGeneratedColumn()
  id: number;

  @Column({ select: true })
  username: string;

  @Column({ select: false }) // 这个字段默认不会被包含
  password: string;
}

const excludedFields = ['password'];
const columns = Object.keys(UserMetadata).filter(key => !excludedFields.includes(key));

const users = await getConnection()
  .getRepository(User)
  .createQueryBuilder('user')
  .select(columns)
  .getRawMany();