Skip to main content

expand_between_in_delete

Function expand_between_in_delete 

Source
pub fn expand_between_in_delete(expr: Expression) -> Result<Expression>
Expand description

Expand BETWEEN expressions in DELETE statements to >= AND <=

Some dialects (like StarRocks) don’t support BETWEEN in DELETE statements or prefer the expanded form. This transforms: DELETE FROM t WHERE a BETWEEN b AND c to: DELETE FROM t WHERE a >= b AND a <= c