使用Typeorm从Postgres数据库返回ROW_NUMBER()

npm install typeorm pg

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

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

  @Column()
  name: string;

  @Column()
  age: number;
}

import { getRepository, QueryBuilder } from "typeorm";
import { User } from "./user.entity";

async function getUsersWithRowNumber() {
  const userRepository = getRepository(User);

  const usersWithRowNumber = await userRepository
    .createQueryBuilder("user")
    .select("ROW_NUMBER() OVER (ORDER BY user.age)", "row_number")
    .addSelect("user.id", "id")
    .addSelect("user.name", "name")
    .addSelect("user.age", "age")
    .getRawMany();

  return usersWithRowNumber;
}