Function normalize_object_name_checked

nodedb-sql/src/parser/normalize.rs:26–50

Normalize a compound object name, rejecting schema-qualified forms. Accepts a single-part name (plain identifier) and returns it normalized. Rejects any name with more than one part (e.g. `public.users`, `db.public.users`) with `SqlError::Unsupported`.

(name: &sqlparser::ast::ObjectName)

/// Rejects any name with more than one part (e.g. `public.users`,
/// `db.public.users`) with `SqlError::Unsupported`.
pub fn normalize_object_name_checked(name: &sqlparser::ast::ObjectName) -> Result<String> {
    if name.0.len() > 1 {
        // Build a human-readable representation of what was actually written.
        let qualified: String = name
            .0
            .iter()
            .map(|part| match part {
                sqlparser::ast::ObjectNamePart::Identifier(ident) => ident.value.clone(),
                _ => String::new(),
            })
            .collect::<Vec<_>>()
            .join(".");
        return Err(SqlError::Unsupported {
            detail: format!("'{qualified}': {SCHEMA_QUALIFIED_MSG}"),
        });
    }
    Ok(name
        .0
        .first()
        .map(|part| match part {
            sqlparser::ast::ObjectNamePart::Identifier(ident) => normalize_ident(ident),
            _ => String::new(),
        })
        .unwrap_or_default())
}

/// Extract table name and optional alias from a table factor.
///