Submit queries through GraphQL or like-wise interface

[vmesel]

A problem I've been working on in my personal projects is the possibility of joining multiple tables and doing multiple filters without limitations imposed by a query file as we have on pREST.

I've been thinking about implementing a GraphQL endpoint that works with all default aggregations depending on the data type and the possibility of joining tables based on the fields given to the API. (Or maybe a custom JSON query type, the only thing we should be able to pass is a list of fields and filters.

The type of JSON I was thinking of is:

{
    query: [
        "table1.field1",
        "sum:table2.field2",
        "avg:table3.field3"
    ],
    filters: [
{
    "filter_type": "where",
    "field_to_be_filtered": "table2.field4",
    "match_type": "equal_or_greater",
    "values": [2.5]
}
]
}