Elixir Blog Post: SQL CASE with Ecto

[fuelen]

Similar topic

Cond in Ecto query DSL

Hi all! Just want to share a small code snippet which allows writing CASE expressions using macro which is similar to cond. Here is an example of usage: import Ecto.Extension.Query.API import Ecto.Query from users in "users", select: %{ email: users.email, role_label: cond_ do users.role == "director" -> "DIRECTOR!" users.inserted_at < ago(6, "month") -> "OLD!" true -> type(users.role, :string) end } generated SQL: SELECT u0."email", CASE WHE…