I’m creating a REST API and i wanna create dynamic queries (e.g generate a SQL query based on a object and yours properties, ignoring null properties) for my routes, what is the best way to approach this?

I heard about query by example, but he couldn’t deal with nested objects (e.g a user that have a address object, that have a street, so on). How to create a fluent solution for this without need create for every entity a query using Criteria with a lot of ifs to ignore null properties and do right joins, etc?