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

Kemahiran: MySQL, PHP, SQL, Pengaturcaraan C#, Kejuruteraan Perisian

Lihat lagi: using fasthost api need help, need help implementing api resellerclub, need help paypal adaptive payment api, rest api filtering best practices, rest api filter fields, rest api filter contains, rest api multiple filter parameters, rest api filter operators, rest api filter not equal, rest api sorting example, rest api filter multiple values, i am a clothes desinger an need help making my dress, i am an undocumented immigrant artist need need help brooklyn, i have bought a theme loma for wordpress to use to design my blog however i am totally stuck and need help in customising my blo, i need help advertising my website, i need help designing a form, i need help designing a shirt, i need help designing clothes, i need help designing my van wrap, i need help find worker

ID Projek: #27901739