feat: Add Op.notStartsWith, Op.notEndsWith and Op.notSubstring

[ReDemoNBR]

Pull Request Checklist

Please make sure to review and check all of these items:

• Have you added new tests to prevent regressions?
• Does yarn test or yarn test-DIALECT pass with this change (including linting)?
• Is a documentation update included (if this change modifies existing APIs, or introduces new ones)?
• Did you update the typescript typings accordingly (if applicable)?
• Does the description below contain a link to an existing issue (Closes #[issue]) or a description of the issue you are solving?
• Did you follow the commit message conventions explained in CONTRIBUTING.md?

Description Of Change

Issue (feature request by myself): #14375

Closes #14375

Todos

• Add operators (notStartsWith, notEndsWith and notSubstring)
• Add tests and ensure no regressions
• Add documentations

[ephys]

Edited your message to mark #14375 as closed by this PR

I would typically be against adding notX versions of operators as you can do { Op.not: Op.startsWith: ... }

But we already have notLike, notILike, and a NOT LIKE b is an actual operator different from NOT (a LIKE b).

I do wish we implemented the new behavior for substring, startsWith, endsWith before extending them. I don't know if we'll have time to do that breaking change before the release of v7 though.

Note that v7 is close to a stable release (still a few months, but close), so v6 is considered feature frozen as much as possible. This will only release with v7

All that being said, this looks good to me. Thank you :)

[github-actions]

🎉 This PR is included in version 7.0.0-alpha.11 🎉

The release is available on:

• npm package (@release-v7 dist-tag)
• GitHub release

Your semantic-release bot 📦🚀