v1.0.9 - Introduce nested jaquel query

[totonga]

This release introduces support for nested statements in Jaquel queries using a new $nested operator. The main changes add the ability to use a nested Jaquel query as a condition, update the documentation, and provide comprehensive tests to ensure correct behavior and error handling for this new feature.

df = con_i.query_data({
      "AoTest": {
          "name": {
              "$in": {
                  "$nested": {
                      "AoTest": {},
                      "$attributes": {
                          "name": {
                              "$distinct": 1
                          }
                      }
                  }
              }
          }
      }
  })

Jaquel $nested operator support

• Added support for the $nested operator in Jaquel queries, allowing conditions to use the result of a nested Jaquel query as a subquery condition. This includes core logic in src/odsbox/jaquel.py to parse, validate, and construct nested statements, with error handling to prevent usage with $null and $notnull operators. [1] [2]
• Updated aggregate suggestion logic to recognize $nested as a valid aggregate.
• Updated Jaquel documentation to describe the $nested operator and its usage.

Maintenance

• Bumped the package version to 1.0.9 in src/odsbox/__init__.py to reflect the new feature.
• Updated the GitHub Actions workflow to use amannn/[email protected] for PR title validation.

What's Changed

• feat: add $nested aggregation to jaquel conditions by @totonga in feat: add $nested aggregation to jaquel conditions #149
• fix: bump amannn/action-semantic-pull-request from 6.0.1 to 6.1.0 by @dependabot[bot] in fix: bump amannn/action-semantic-pull-request from 6.0.1 to 6.1.0 #147
• feat: Added aggregate $nested to jaquel query by @totonga in feat: Added aggregate $nested to jaquel query  #150

Full Changelog: v1.0.8...v1.0.9

---

This discussion was created from the release v1.0.9.