如何使用typeorm构建复杂的sql查询

npm install typeorm

{
  "type": "mysql",
  "host": "localhost",
  "port": 3306,
  "username": "root",
  "password": "password",
  "database": "mydatabase",
  "synchronize": true,
  "logging": true,
  "entities": [
    "src/entities/*.ts"
  ],
  "migrations": [
    "src/migrations/*.ts"
  ],
  "subscribers": [
    "src/subscribers/*.ts"
  ]
}

import { Entity, Column, PrimaryGeneratedColumn } from 'typeorm';

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

  @Column()
  name: string;

  @Column()
  age: number;
}

import { EntityRepository, Repository } from 'typeorm';
import { User } from '../entities/User';

@EntityRepository(User)
export class UserRepository extends Repository<User> {
  async findAdultUsers(): Promise<User[]> {
    return this.createQueryBuilder('user')
      .where('user.age >= :age', { age: 18 })
      .getMany();
  }
}

import { createConnection } from 'typeorm';
import { UserRepository } from './repositories/UserRepository';

async function main() {
  const connection = await createConnection();
  const userRepository = connection.getCustomRepository(UserRepository);

  const adultUsers = await userRepository.findAdultUsers();
  console.log(adultUsers);
}

main().catch(console.error);