Filter and conditional operators
We natively support all dialect specific filter and conditional operators.
You can import all filter & conditional from drizzle-orm
:
eq
Value equal to n
ne
Value is not equal to n
gt
Value is greater than n
gte
Value is greater than or equal to n
lt
Value is less than n
lte
Value is less than or equal to n
.
isNull
Value is null
isNotNull
Value is not null
inArray
Value is in array of values
notInArray
Value is not in array of values
exists
Value exists
notExists
between
Value is between two values
notBetween
Value is not between two value
like
Value is like other value, case sensitive
ilike
Value is like some other value, case insensitive
notIlike
Value is not like some other value, case insensitive
not
All conditions must return false
.
and
All conditions must return true
.
or
One or more conditions must return true
.
arrayContains
Test that a column or expression contains all elements of the list passed as the second argument
arrayContained
Test that the list passed as the second argument contains all elements of a column or expression
arrayOverlaps
Test that a column or expression contains any elements of the list passed as the second argument.