Need help with advanced filter for API endpoint

I`d like to get best practise with example and get best library for advanced filtring thrue API endpoint. Data are stored in SQL and have multiple JOINs relationship. Filter operator: "AND", if posible also "OR" Filter types: None, equal, not equal, grater than, grater than and equal, less than, less than or equal, contains, not contains, start with, not start with, end with, not end with, any, not any, IN, not IN, is null, not null, empty, not empty, is null or empty, is not null or empty Latency in miliseconds