search

neuroforgede / nfcompose

Build REST APIs/Integrations in minutes instead of hours - NF Compose is a (data) integration platform that allows developers to define REST APIs in seconds instead of hours. Generated REST APIs are backed by postgres and support automatic consumer webhook notifications on data changes out of the box.
Mozilla Public License 2.0
33 stars 3 forks source link

Add support for more complex filters #59

Closed s4ke closed 11 months ago

s4ke commented 11 months ago

We should add support for some more basic operators together with "$and" and "$or" to give users better control over filters. We will not add jsonb filtering for now (as that needs more thought regarding traversing), nor will we add filters for file facts or image facts for now.

single_valued_sql_operators = {
    "$eq": "=",
    "$lt": "<",
    "$lte": "<=",
    "$ne": "!=",
    "$gte": ">=",
    "$gt": ">"
}

multi_valued_sql_operators = {
    "$in": "IN",
    "$nin": "NOT IN"
}