Function check_identifier

nodedb-sql/src/reserved.rs:57–73

Validate a raw identifier token extracted from SQL. If `raw_name` is surrounded by double-quotes (standard SQL quoting), the quotes are stripped and the inner text is returned unchanged as `Ok(inner)` — the user has opted in to the reserved word. Otherwise, the token is normalised to upper case and compared against [`RESERVED_KEYWORDS`]. A match returns `Err(SqlError::ReservedIdentifier { .. })`

(raw_name: &str)

/// * A clean identifier is returned as `Ok(name.to_lowercase())` to match
///   the existing `parse_col_token` behaviour.
pub fn check_identifier(raw_name: &str) -> Result<String, SqlError> {
    if raw_name.starts_with('"') && raw_name.ends_with('"') && raw_name.len() >= 2 {
        // Standard SQL quoted identifier: strip the surrounding quotes.
        return Ok(raw_name[1..raw_name.len() - 1].to_string());
    }

    let upper = raw_name.to_uppercase();
    if RESERVED_KEYWORDS.contains(&upper.as_str()) {
        let reason = reason_for(&upper);
        return Err(SqlError::ReservedIdentifier {
            name: raw_name.to_string(),
            reason,
        });
    }

    Ok(raw_name.to_lowercase())
}

#[cfg(test)]
mod tests {