typeorm使用现有sql视图

import { Entity, ViewEntity, ViewColumn } from "typeorm";

@ViewEntity({
  name: "view_name",
  expression: "SELECT * FROM view_name"
})
@Entity()
export class ViewEntityName {
  @ViewColumn()
  column1: string;

  @ViewColumn()
  column2: number;
}

import { createConnection } from "typeorm";
import { ViewEntityName } from "./path/to/view-entity-name.entity";

createConnection({
  // ...
  entities: [
    // ...
    ViewEntityName
  ],
  // ...
});

import { getRepository } from "typeorm";
import { ViewEntityName } from "./path/to/view-entity-name.entity";

const viewRepository = getRepository(ViewEntityName);

// 查询所有数据
const allData = await viewRepository.find();

// 根据条件查询数据
const filteredData = await viewRepository.find({
  where: {
    column1: "value"
  }
});

// 其他查询操作...