What's the recommended way to do a basic filter by a boolean column's value?

I can't figure out how to use a non-filter expression for filtering.

e.g., I would expect db.select().from(appointment).where(appointment.canceled) to generate the equivalent sql select * from appointment where appointment.canceled, which works exactly how I expect. .where(() => appointment.canceled) or .where((a) => a.canceled) don't work either.

I can use
.where(sql`${appointment.canceled}`)

but surely there must be a simpler way?

I can provide this column as an argument to a filter, so why can't I use this column itself as a filter?
Was this page helpful?