IsNot
Negated IS-comparison, typically used for "not null" checks (left is not right). Extends
Is. Shorthand keys: isNot, !is.
Constructor
IsNot(left: string | SqlElement, right?: any): IsNot
new IsNot(left: string | SqlElement, right?: any): IsNot
Dual-callable, same argument shape as Is.
import { IsNot, Select } from '@sqb/builder';
Select().from('customers').where(IsNot('deleted_at', null));
// where deleted_at is not null
Properties
Inherits every property from Is (_type, _left, _right, _symbol, _isArray);
_symbol is always 'is not'.
Methods
Inherits ._serialize() from CompOperator
(via Is); IsNot adds no methods of its own.
Object-literal shorthand
Select().from('customers').where({ 'deleted_at !is': null });
// where deleted_at is not null