Implement NOT Condition in where Clauses

[teles]

Implement NOT Condition in where Clauses

Description:

Add support for logical NOT conditions in where clauses, allowing queries to exclude records that meet certain conditions.

Objective:

• Enable the negation of specific conditions using logical NOT in queries.
• Update the syntax of the where parameters to support objects representing negated conditions.
• Ensure the implementation is intuitive and consistent with existing filtering functionalities.

Acceptance Criteria:

• Calling findMany({ where: { NOT: { condition } } }) returns records that do not meet the specified condition.
• Documentation updated with examples demonstrating the use of NOT.
• Automated tests cover various scenarios of negated conditions.

[teles]

Partial progress

✅ Done: Field-level not filter exists in whereFilters.ts — negation at the value level already works:

findMany({ where: { status: { not: 'inactive' } } })

❌ Still needed: Top-level NOT combinator per the acceptance criteria:

findMany({ where: { NOT: { status: 'inactive' } } })

WhereService needs to detect the NOT key and return rows that do not match the inner sub-clause.