Querying raw SQL with Elixir and Ecto

TL;DR: alias MyApp.{Repo, Animal} sql = "SELECT * FROM animals WHERE legs > $1" params = [2] %{rows: rows, columns: columns} = Repo.query!(sql, params) Enum.map(rows, fn row -> Repo.load(Animal, {columns, row}) end) It was surprisingly difficult ...