How to Obtain the Type of the Where Clause?

[riculum]

I'm working with Dirzzle ORM for PostgreSQL in TypeScript, and I'm trying to improve the type safety of my code. Specifically, I'm wondering if there's a way to infer the type of the where clause in a query, so that I can avoid using any in my function signatures.

Here's an example of what I'm currently doing:

async function getTotalCount<T extends AnyPgTable>(schema: T, condition?: any): Promise<number> {
  const [maxItems] = await db.select({ count: count() }).from(schema).where(condition)
  return maxItems.count
}

In this function, I'm using condition?: any to accept any type of condition for the where clause. However, I'd like to replace any with a more specific type that corresponds to the actual type of the where clause.

[ChoaibMouhrach]

Anything on this ?

[ramonfritsch]

Doing exactly this as well, any answers?