Understanding the Limitations of R's case_when Function When Handling Mixed Variables

Using Variables in SQL CASE WHEN Statements to Simplify Complex Queries