feat: query builder negating with "NotBrackets" for complex expressions

[christian-forgacs]

Query builder negating with "NotBrackets" for complex expressions

You can add a negated complex WHERE expression into an existing WHERE using NotBrackets

createQueryBuilder("user")
    .where("user.registered = :registered", { registered: true })
    .andWhere(new NotBrackets(qb => {
        qb.where("user.firstName = :firstName", { firstName: "Timber" })
          .orWhere("user.lastName = :lastName", { lastName: "Saw" })
    }))

Which will produce the following SQL query:

SELECT ... FROM users user WHERE user.registered = true AND NOT((user.firstName = 'Timber' OR user.lastName = 'Saw'))

Closes feature request #4442.

We can't use Not as class because it's already exported in src/find-options/operator/Not.ts.

Pull-Request Checklist

• Code is up-to-date with the master branch
• npm run lint passes with this change
• npm run test passes with this change
• This pull request links relevant issues as Fixes #0000
• There are new or updated unit tests validating the change
• Documentation has been updated to reflect this change
• The new commits follow conventions explained in CONTRIBUTING.md

[pleerock]

Thank you for contribution! 🎉

[nalhusail]

is this released? I can't find it in latest version (v0.2.41)

[christian-forgacs]

@nalhusail atm not. @pleerock will it released in 0.3.0?

[christian-forgacs]

@nalhusail it is now released with the release 0.2.42