Struct CaseBuilder 

pub struct CaseBuilder { /* private fields */ }

Fluent builder for SQL CASE expressions (both searched and simple forms).

Created by case() (searched form) or case_of() (simple form). Add branches with .when() and an optional default with .else_(). Finalize with .build() to get an Expr, or .build_expr() for a raw Expression.

Implementations

impl CaseBuilder

pub fn when(self, condition: Expr, result: Expr) -> Self

Add a WHEN condition THEN result branch to the CASE expression.

For a searched CASE (case()), condition is a boolean predicate. For a simple CASE (case_of()), condition is the value to compare against the operand.

pub fn else_(self, result: Expr) -> Self

Set the ELSE result default branch of the CASE expression.

If not called, the CASE expression has no ELSE clause (implicitly NULL when no WHEN matches).

pub fn build(self) -> Expr

Consume this builder and produce an Expr wrapping the CASE expression.

pub fn build_expr(self) -> Expression

Consume this builder and produce the raw Expression::Case AST node.

Use this instead of .build() when you need the Expression directly rather than an Expr wrapper.