Supports both new and old analyzers.

Some optimizations are not yet supported with negative LIMIT. Additionally, LIMIT BY and WITH TIES are not supported for now. I will add the support eventually in future PRs.

Examples:

SELECT number
FROM numbers(10)
LIMIT -3 OFFSET -2

   ┌─number─┐
1. │      5 │
2. │      6 │
3. │      7 │
   └────────┘

SELECT number
FROM numbers(10)
OFFSET -8

   ┌─number─┐
1. │      0 │
2. │      1 │
   └────────┘

Changelog category (leave one):

• New Feature

Changelog entry (a user-readable short description of the changes that goes into CHANGELOG.md):

Add support for negative LIMIT and negative OFFSET. Closes #28913

Documentation entry for user-facing changes

• Documentation is written (mandatory for new features)