The macro EctoQuery dynamic/2 allows you to build query fragments and interpolate them into one large query.

We get easy-to-manage query building in an accessible way. It allows you to control the parameters from the user and transparently create filtering of data stored in the database.

Check on: Dynamic Queries in Ecto