The ODataFilterLanguage uses bitwise instead of logical AND/OR operators which leads to long running SQL queries, because the conditions are casted as BIT and compared against 0 or 1 instead of checking if the condition is met (True) or not (False).
@alex-davies I would be happy to fix this, but I don't have the permissions to create branches and therefore am not able to create a PR.
The ODataFilterLanguage uses bitwise instead of logical AND/OR operators which leads to long running SQL queries, because the conditions are casted as BIT and compared against 0 or 1 instead of checking if the condition is met (True) or not (False).
@alex-davies I would be happy to fix this, but I don't have the permissions to create branches and therefore am not able to create a PR.