feature request: case_when() TRUE should translate to ELSE

[namarkus]

sql translation of case_when() has no else clause

case_when works just fine with dataframes. Using it in a database environment, I'm missing the possibility of defining an else-clause:

translate_sql(case_when(
  height > 200 | mass > 200 ~ "large",
  species == "Droid"        ~ "robot",
  TRUE                      ~  "other"
))

translates to:
(...) WHEN (TRUE) THEN ('other') END
whereas it should translate to:
(...) ELSE ('other') END

[ghost]

This issue was moved by batpigandme to tidyverse/dbplyr/issues/102.

[lock]

This old issue has been automatically locked. If you believe you have found a related problem, please file a new issue (with reprex) and link to this issue. https://reprex.tidyverse.org/