Function strip_as_of_system_time

nodedb-sql/src/parser/preprocess/temporal.rs:294–306

Match `AS OF SYSTEM TIME ` (case-insensitive) anywhere in `sql` and strip it. The expression may be an integer literal, `NOW()`, or an ISO-8601 timestamp string. Returns `None` if the clause is absent. This is the CockroachDB-inspired form used on array read queries. It is parsed by NodeDB's pre-processor (option b — string-based extraction before sqlparser-rs sees the statement) because sq

(sql: &str)

/// consistent and avoids mixing native sqlparser AS-OF support with custom
/// preprocessing in the same pipeline.
fn strip_as_of_system_time(sql: &str) -> Result<Option<(String, i64)>, TemporalParseError> {
    let keyword = "AS OF SYSTEM 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)))
}

/// Match `AS OF VALID TIME <expr>` (case-insensitive) anywhere in `sql` and
/// strip it. Same expression forms as `strip_as_of_system_time`. Returns `None`