Optional filter param, coalesce to true?

Is there a way to achieve this coalescing technique, but in valid drizzle sql?

const filterByBool: boolean | undefined | null = undefined

await db
  .select()
  .from(test)
  .where(test.bool == filterByBool ?? true)

const filterByBool: boolean | undefined | null = undefined

await db
  .select()
  .from(test)
  .where(test.bool == filterByBool ?? true)

const filterByBool: boolean | undefined | null = undefined

await db
  .select()
  .from(test)
  .where(test.bool == filterByBool ?? true)

const filterByBool: boolean | undefined | null = undefined

await db
  .select()
  .from(test)
  .where(test.bool == filterByBool ?? true)

rphlmr ⚡•5/27/23, 6:44 AM

const filterByBool: boolean | undefined | null = undefined

await db
  .select()
  .from(test)
  .where(eq(test.bool,filterByBool ?? true))

const filterByBool: boolean | undefined | null = undefined

await db
  .select()
  .from(test)
  .where(eq(test.bool,filterByBool ?? true))

should works

rphlmr ⚡•5/27/23, 6:45 AM

eq comes from drizzle import

Andrii Sherman•5/27/23, 8:09 AM

For some advanced filters you can use this example

Andrii Sherman•5/27/23, 8:09 AM

Andrii Sherman•5/27/23, 8:10 AM

all you need from this examples is that filter statements can be grouped in array

Andrii Sherman•5/27/23, 8:10 AM

And then used in where + and(…filters)

mcgrealifeOP•5/27/23, 9:43 PM

Thanks to both! Being able to use javascript inside a query builder is delightful.