feature request: case_when() TRUE should translate to ELSE

[ghost]

@namarkus commented on Jun 20, 2018, 2:47 PM UTC:

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

This issue was moved by batpigandme from tidyverse/dplyr/issues/3688.

[cderv]

this is related to tidyverse/dplyr#3521 (not moved to dbplyr yet)
It is still WIP for an all-database solution.

[krlmlr]

Moved to #112 now.