Organize The Application Core and Boundary

In the previous lessons, we didn’t need to execute more complex queries than the CRUD-supporting ones provided by generated code. Our survey feature is a bit different, however. To support the survey functionality, we’ll need to execute some custom queries. In this lesson, we’ll learn how to compose and execute complex database queries with Ecto, and we’ll see how this work fits into the organized core and boundary layers of an application. Then, we’ll be ready to use our custom queries in the survey LiveView.

Ecto query composition, as we already know, is certain and predictable. It belongs in our application’s core. But where exactly in the core should we put code that dynamically constructs complex queries?

Queries are a little bit like functions. It’s fine to express short ones in-line, much like anonymous functions, within the scope of a module like a context. However, it is important to provide a first-class function to express and name more complex queries. These functions belong in their very own ...