[BUG]:

[CaptainYarb]

What version of drizzle-orm are you using?

0.29.3

What version of drizzle-kit are you using?

n/a

Describe the Bug

Conditional helper functions such as isNull, isNotNull, exists, notExists cannot be used within a query select, without returning an unknown type.

const results = await db
    .select({
      id: table.id,
      has_title_orm: isNotNull(table.name),
      has_title_sql: sql<boolean>`${table.name} IS NOT NULL`,
    })
    .from(table);

  results[0].has_title_orm; // unknown type
  results[0].has_title_sql; // boolean type

Expected behavior

The sql wrapper used should be able to be typed for these boolean returns. I can imagine that there's a circumstance where you might not want to, given the fact these query helpers can be used in other places?

Environment & setup

Example Stackblitz: https://stackblitz.com/edit/typescript-5bbctn?file=index.ts

[AndriiSherman]

Thanks a lot! I'll mark it as improvement and we will implement this

[JohnAllenTech]

Any update on this one?

[glassworks-projects]

+1

[whysocket]

+1

[cluah]

hi, here are two more workarounds:

sql<boolean>`${isNotNull(table.column)}`
isNotNull(table.column).mapWith(Boolean)