如何改进CASE WHEN语句在同一行返回结果

SELECT 
    column1,
    CASE 
        WHEN condition1 THEN result1
        WHEN condition2 THEN 
            CASE 
                WHEN nested_condition1 THEN nested_result1
                WHEN nested_condition2 THEN nested_result2
                ELSE nested_result3
            END
        ELSE result2
    END AS result
FROM table;

SELECT 
    column1,
    CASE 
        WHEN condition1 AND condition2 THEN result1
        WHEN condition3 OR condition4 THEN result2
        ELSE result3
    END AS result
FROM table;

SELECT 
    column1,
    CASE 
        WHEN column2 IN (value1, value2, value3) THEN result1
        WHEN column3 IN (value4, value5) THEN result2
        ELSE result3
    END AS result
FROM table;

SELECT 
    column1,
    CASE 
        WHEN condition1 THEN result1
        WHEN condition2 AND condition3 THEN result2
        WHEN condition4 OR condition5 THEN result3
        ELSE result4
    END AS result
FROM table;