From an end user standpoint, I preferred working with such API than with the ones creating nested json filters structures to model the filtering logic.
It also provides a convenient way to select fields in the response, better in my opinion than "field mask" alternative that you can find on other APIs.
https://developers.google.com/google-ads/api/docs/query/over... https://developer.intuit.com/app/developer/qbo/docs/learn/ex... https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.... https://carto.com/developers/sql-api/
From an end user standpoint, I preferred working with such API than with the ones creating nested json filters structures to model the filtering logic. It also provides a convenient way to select fields in the response, better in my opinion than "field mask" alternative that you can find on other APIs.