import { isNotNull, sql } from "drizzle-orm"
import { db } from "@/lib/db/client"
import { people } from "@/lib/db/schema"
const rows = await db
  .select({ u: people.username, l: people.language })
  .from(people)
  .where(isNotNull(people.username))
  .orderBy(people.username)
console.log(rows)
const [d] = await db
  .select({ n: sql<number>`count(*) filter (where ${people.language} = 'th')::int`,
            t: sql<number>`count(*)::int` })
  .from(people)
console.log("thaï dans tout le roster :", d)
process.exit(0)