search

Azure / data-api-builder

Data API builder provides modern REST and GraphQL endpoints to your Azure Databases and on-prem stores.
https://aka.ms/dab/docs
MIT License
852 stars 173 forks source link

Add more OData expression support to $filter #936

Open yorek opened 1 year ago

yorek commented 1 year ago

Right now, the $filter REST option supports the native OData operations:

http://docs.oasis-open.org/odata/odata/v4.01/cs01/part1-protocol/odata-v4.01-cs01-part1-protocol.html#sec_BuiltinFilterOperations

feedback from some early adopters is emerging in the sense that we should support also some of the native OData query functions:

http://docs.oasis-open.org/odata/odata/v4.01/cs01/part1-protocol/odata-v4.01-cs01-part1-protocol.html#sec_BuiltinQueryFunctions

we should see how many of those can be pushed to the database engine to make sure we can push as much as possible the computation effort to the database

Licantrop0 commented 8 months ago

Data API builder should output standard OData. It would conform also to Microsoft Graph (supporting expands, navigation properties, grouping, etc...) and there are already standard libraries to interact with it: https://github.com/OData/odata.net

Andy65 commented 4 months ago

At the very least it should support: contains and ideally should also support startsWith and endsWith