feat: validate filter, sort, range, select

[ymarcon]

The corresponding json schema would look like this:

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "title": "ENAC-IT4R Python SQL Utils",
  "type": "object",
  "properties": {
    "filter": {
      "type": "object",
      "additionalProperties": {
        "type": "object",
        "properties": {
          "$and": {
            "type": "array",
            "items": { "$ref": "#" }
          },
          "$or": {
            "type": "array",
            "items": { "$ref": "#" }
          },
          "$eq": { "type": "string" },
          "$ne": { "type": "string" },
          "$lt": { "type": "number" },
          "$lte": { "type": "number" },
          "$le": { "type": "number" },
          "$gt": { "type": "number" },
          "$gte": { "type": "number" },
          "$ge": { "type": "number" },
          "$ilike": { "type": "string" },
          "$like": { "type": "string" },
          "$contains": {
            "type": "array",
            "items": { "type": "string" }
          },
          "$in": {
            "type": "array",
            "items": { "type": "string" }
          },
          "$nin": {
            "type": "array",
            "items": { "type": "string" }
          },
          "$exists": { "type": "boolean" }
        },
        "additionalProperties": true
      }
    },
    "sort": {
      "type": "array",
      "items": [
        { "type": "string" },
        { "type": "string", "enum": ["ASC", "DESC"], "default": "ASC" }
      ],
      "minItems": 1,
      "maxItems": 2
    },
    "range": {
      "type": "array",
      "items": { "type": "integer" },
      "minItems": 2,
      "maxItems": 2
    },
    "select": {
      "type": "array",
      "items": { "type": "string" },
      "minItems": 0
    }
  },
  "required": ["filter"],
  "additionalProperties": false
}