NOT

Creates a logical NOT expression.

This function negates the result of a given expression. It is commonly used to reverse a condition in a WHERE or HAVING clause.

Example

// Generates: NOT ("age" < 18)
NOT(Employees.age LT 18)

// Generates: NOT ("country" = 'USA' AND "status" = 'active')
NOT((Employees.country EQ "USA") AND (Employees.status EQ "active"))

Parameters

Creates a logical NOT expression for a subquery.

This function negates the result of a subquery. It's often used with EXISTS or other subquery-based conditions, although its direct use (NOT (subquery)) is less common in standard SQL than NOT EXISTS or NOT IN. The behavior may vary across SQL dialects. For checking non-existence, NOT_EXISTS is generally preferred.

Example

// Generates: NOT (SELECT "order_time" FROM "Orders" WHERE "customer_id" = "Customers"."id")
// This is functionally similar to NOT_EXISTS in many cases.
NOT(
    Orders.select(Orders.orderTime).where { Orders.customerId EQ Customers.id }
)

Parameters

See also