# `QuackDB.Ecto.Conditionals`
[🔗](https://github.com/elixir-vibe/quackdb/blob/main/lib/quack_db/ecto/conditionals.ex#L2)

Conditional expression helpers for Ecto analytical queries.

`case_when/1` keeps multi-branch SQL `CASE WHEN` expressions readable while
preserving normal Ecto operators inside each condition:

    use QuackDB.Ecto

    from event in "events",
      select: %{
        tier:
          case_when do
            event.score >= 90 -> "high"
            event.score >= 50 -> "medium"
            true -> "low"
          end
      }

The expression compiles to DuckDB `CASE WHEN ... THEN ... ELSE ... END`.

# `case_when`
*macro* 

---

*Consult [api-reference.md](api-reference.md) for complete listing*