Standardize Criteria Query and Introduce KeySet Pagination

[otaviojava]

Which JNoSQL project the issue refers to?

JNoSQL (Core)

Use case

Currently, the project has separate classes for DocumentQuery and ColumnQuery, as well as DocumentDeleteQuery and ColumnDeleteQuery, which contain similar fields. The objective is to unify these classes into two shared API classes: SelectQuery and DeleteQuery.

This unification will pave the way for implementing KeySet pagination and enhancing the CriteriaQuery functionality.

Feature proposal

Objective:

• Unify DocumentQuery and ColumnQuery into SelectQuery.

• Unify DocumentDeleteQuery and ColumnDeleteQuery into DeleteQuery.

• Implement KeySet pagination.

• Enhance CriteriaQuery.

  Expected Outcome:

• Reduced code duplication by unifying query classes.

• Introduction of KeySet pagination feature for efficient large dataset retrieval.

• Improved CriteriaQuery functionality for more flexible and powerful querying operations.

[redmitry]

Is there any work to support JSONPath queries?

"path": "$.measures[?@.assayCode.id == 'LOINC:3141-9' && @.measurementValue.value $operator '$value']"

Currently, I have to directly generate mongo queries, because I found no way to support something like:

{
  "measures": {
    "$elemMatch": {
      "assayCode.id": "LOINC:35925-4", 
      "measurementValue.value": {"$gt": 25}
    }
  }
}

Thank you,

D.