I always like to bring up Ecto. Really nice sweet spot IMO.

  query = from u in "users",
            where: u.age > 18 or is_nil(u.email),
            select: %{name: u.name, age: u.age}
  
  # Returns maps as defined in select
  Repo.all(query)

https://hexdocs.pm/ecto/Ecto.html#module-query