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
Read next Application Code Upgrades in Elixir