Error when fetching data from database view

export const clients = pgTable("clients", {
  id: integer().primaryKey().generatedAlwaysAsIdentity(),
  name: varchar({ length: 30 }).notNull(),
  email: varchar({ length: 30 }).notNull(),
  phone: varchar({length: 15}).notNull(),
  clientType: varchar("client_type", {enum: ["business", "individual"]}).notNull(),
  address: varchar().notNull(),
  status: varchar({ enum: ["active", "inactive"] }).notNull(),
  notes: varchar({length: 256})
});

export const clientRelations = relations(clients, ({ many }) => ({
  invoices: many(invoices),
}));

export const clientStatsViews = pgView("client_stats").as(
  (qb) => qb.select({
    totalCount: sql<number>`cast(count(*) as int)`.as("total_clients"),
    inactiveCount: sql<number>`cast(count(${clients.id}) filter (where ${clients.status} = 'inactive') as int)`.as("inactive_clients"),
    activeCount: sql<number>`cast(count(${clients.id}) filter (where ${clients.status} = 'active') as int)`.as("active_clients"),
  }).from(clients)
)