{
  "mul": {
    "category": "FUNCTION",
    "operation": "MUL",
    "type": "INTEGER",
    "rank": "VALUE",
    "operands": [
      {
        "category": "FUNCTION",
        "operation": "SUM",
        "type": "INTEGER",
        "rank": "VALUE",
        "operands": [
          {
            "category": "FUNCTION",
            "operation": "FETCH_ONE",
            "type": "INTEGER",
            "rank": "VALUE",
            "operands": [
              {
                "category": "ID",
                "type": "DATASET",
                "id": {
                  "type": "CATALOGUE",
                  "service": "test-application",
                  "register": "handbook",
                  "catalogue": "111e4567-e89b-12d3-a456-426655440000"
                }
              },
              {
                "category": "ENTITY_ATTRIBUTE",
                "type": "INTEGER",
                "rank": "TUPLE",
                "path": "shieldTypes",
                "field": {
                  "schema": "public",
                  "table": "handbook_entry_version",
                  "field": "data"
                }
              },
              {
                "category": "PREDICATE",
                "operation": "EQ",
                "operands": [
                  {
                    "category": "ENTITY_ATTRIBUTE",
                    "type": "STRING",
                    "rank": "VALUE",
                    "path": "type",
                    "field": {
                      "schema": "public",
                      "table": "handbook_entry_version",
                      "field": "data"
                    }
                  },
                  {
                    "category": "LITERAL",
                    "type": "STRING",
                    "value": "CAPITAL_SHIP"
                  }
                ]
              }
            ]
          }
        ]
      },
      {
        "category": "SCOPE_ATTRIBUTE",
        "type": "INTEGER",
        "rank": "VALUE",
        "position": null,
        "path": "b"
      }
    ]
  },
  "avg": {
    "category": "FUNCTION",
    "operation": "AVG",
    "type": "NUMBER",
    "rank": "VALUE",
    "operands": [
      {
        "category": "FUNCTION",
        "operation": "FETCH_ONE",
        "type": "INTEGER",
        "rank": "VALUE",
        "operands": [
          {
            "category": "ID",
            "type": "DATASET",
            "id": {
              "type": "CATALOGUE",
              "service": "test-application",
              "register": "handbook",
              "catalogue": "111e4567-e89b-12d3-a456-426655440000"
            }
          },
          {
            "category": "ENTITY_ATTRIBUTE",
            "type": "INTEGER",
            "rank": "TUPLE",
            "path": "shieldTypes",
            "field": {
              "schema": "public",
              "table": "handbook_entry_version",
              "field": "data"
            }
          },
          {
            "category": "PREDICATE",
            "operation": "EQ",
            "operands": [
              {
                "category": "ENTITY_ATTRIBUTE",
                "type": "STRING",
                "rank": "VALUE",
                "path": "type",
                "field": {
                  "schema": "public",
                  "table": "handbook_entry_version",
                  "field": "data"
                }
              },
              {
                "category": "LITERAL",
                "type": "STRING",
                "value": "CAPITAL_SHIP"
              }
            ]
          }
        ]
      }
    ]
  },
  "c.e.g": {
    "category": "PREDICATE",
    "operation": "GT",
    "operands": [
      {
        "category": "SCOPE_ATTRIBUTE",
        "type": "INTEGER",
        "rank": "VALUE",
        "position": "c",
        "path": "d.count"
      },
      {
        "category": "LITERAL",
        "type": "INTEGER",
        "value": "200"
      }
    ]
  },
  "c.d.events.nextDay": {
    "category": "FUNCTION",
    "operation": "ADD",
    "type": "DATE_TIME",
    "rank": "VALUE",
    "operands": [
      {
        "category": "SCOPE_ATTRIBUTE",
        "type": "DATE_TIME",
        "rank": "VALUE",
        "position": "c.d.events",
        "path": "date"
      },
      {
        "category": "LITERAL",
        "type": "INTEGER",
        "value": "1"
      }
    ]
  },
  "c.concat": {
    "category": "FUNCTION",
    "operation": "CONCAT",
    "type": "STRING",
    "rank": "VALUE",
    "operands": [
      {
        "category": "SCOPE_ATTRIBUTE",
        "type": "STRING",
        "rank": "VALUE",
        "path": "a"
      },
      {
        "category": "SCOPE_ATTRIBUTE",
        "type": "STRING",
        "rank": "VALUE",
        "position": "c",
        "path": "d.name"
      }
    ]
  },
  "c.e.h": {
    "category": "PREDICATE",
    "operation": "EQ",
    "operands": [
      {
        "category": "SCOPE_ATTRIBUTE",
        "type": "INTEGER",
        "rank": "VALUE",
        "position": "c",
        "path": "d.absent"
      },
      {
        "category": "LITERAL",
        "type": "INTEGER",
        "value": "404"
      }
    ]
  },
  "u": {
    "category": "LITERAL",
    "type": "UUID",
    "value": "bb743523-f390-4a08-834e-9d1c592ccec3"
  }
}