gistfile1.clj

(project (table :t1)
         [:id :title]
         (case :alias??
           (<= :wage 200)
           "low"
           (and (> :wage 200) (< :wage 400))
           "average"
           (>= :wage 400)
           "high"
           :else "negative"))

"SELECT id,title,
   CASE WHEN (wage <= 200) THEN low
        WHEN (wage > 200 AND wage < 400) THEN average
        WHEN (wage >= 400) THEN high
    ELSE
     negative
   END AS alias
  FROM t1"