API GET Endpoints - Revamp of filters

[geoff-maddock]

As a user of the API GET endpoints, I would like to create a more robust and dynamic way of making a request to filter the results via an HTTP request.
Currently the filters are passed as query parameters such as:
https://url?filters[column1]=value1&filters[column2]=value2

However, I would like something that allows for the creation of more robust queries, such as
https://url?filters=column1 EQ value1
https://url?filters=column1 not EQ value1
https://url?filters=column1 > value1
https://url?filters=column1 IN (value1, value2, value3)
https://url?filters=(column1 EQ value1 OR column2 EQ value2) AND (column3 EQ value3)

Transform the filters into the right query builder queries and apply them.
Allow for any of the standard MYSQL clauses