✨This talk was recorded at Code BEAM America 2022. If you're curious about our upcoming event, check https://codebebeamamerica.com ✨ The Ecto.Query DSL gives us a wonderfully expressive tool for fetching data. With a little bit of extra magic, we can create composable, human-readable, expressive, pipeline-able methods that reveal the human meaning behind the data we’re accessing, rather than the implementation details of the DB schema itself. In this talk, I’ll show how to begin decomposing existing queries (and creating new queries) with composable queries, how to organize those queries, and how to make them discoverable. I’ll also show how to accomplish common joins, make use of subqueries, and other common SQL operations.