Function strip_as_of_valid_time

nodedb-sql/src/parser/preprocess/temporal.rs:311–323

Match `AS OF VALID TIME ` (case-insensitive) anywhere in `sql` and strip it. Same expression forms as `strip_as_of_system_time`. Returns `None` if the clause is absent.

(sql: &str)

/// strip it. Same expression forms as `strip_as_of_system_time`. Returns `None`
/// if the clause is absent.
fn strip_as_of_valid_time(sql: &str) -> Result<Option<(String, i64)>, TemporalParseError> {
    let keyword = "AS OF VALID TIME";
    let Some(start) = keyword_position_outside_literals(sql, keyword) else {
        return Ok(None);
    };
    let after_kw = start + keyword.len();
    let (ms, end_abs) = parse_as_of_expr(sql, after_kw)?;
    let mut out = String::with_capacity(sql.len());
    out.push_str(sql[..start].trim_end());
    out.push(' ');
    out.push_str(sql[end_abs..].trim_start());
    Ok(Some((out.trim().to_string(), ms)))
}

/// Extract the temporal expression that follows an AS-OF keyword at `offset`
/// in `sql`. Returns `(resolved_ms, end_offset_exclusive)`.