Module st_002 

LINT_ST_002: Unnecessary CASE statement.

SQLFluff ST02 parity: detect CASE expressions that can be replaced by simpler forms such as COALESCE(...), NOT COALESCE(...), or a plain column reference.

Detectable patterns:

1. CASE WHEN cond THEN TRUE ELSE FALSE END → COALESCE(cond, FALSE)
2. CASE WHEN cond THEN FALSE ELSE TRUE END → NOT COALESCE(cond, FALSE)
3. CASE WHEN x IS NULL THEN y ELSE x END → COALESCE(x, y)
4. CASE WHEN x IS NOT NULL THEN x ELSE y END → COALESCE(x, y)
5. CASE WHEN x IS NULL THEN NULL ELSE x END → x
6. CASE WHEN x IS NOT NULL THEN x ELSE NULL END → x
7. CASE WHEN x IS NOT NULL THEN x END → x

Structs

StructureSimpleCase