Function replace 

pub fn replace<'a, V, E, F, T>(
    expr: E,
    from: F,
    to: T,
) -> SQLExpr<'a, V, <V::DialectMarker as DialectTypes>::Text, E::Nullable, <<E::Aggregate as AggOr<F::Aggregate>>::Output as AggOr<T::Aggregate>>::Output>
where
    V: SQLParam + 'a,
    E: Expr<'a, V>,
    E::SQLType: Textual,
    F: Expr<'a, V>,
    F::SQLType: Textual,
    F::Aggregate: AggregateKind,
    T: Expr<'a, V>,
    T::SQLType: Textual,
    T::Aggregate: AggregateKind,
    E::Aggregate: AggOr<F::Aggregate>,
    <E::Aggregate as AggOr<F::Aggregate>>::Output: AggOr<T::Aggregate>,

REPLACE - replaces occurrences of a substring.

Replaces all occurrences of from with to in the expression. Preserves the nullability of the input expression.

Example

use drizzle_core::expr::replace;

// SELECT REPLACE(users.email, '@old.com', '@new.com')
let new_email = replace(users.email, "@old.com", "@new.com");