Function build_vector_search_sql

nodedb-client/src/remote/sql.rs:27–42

Build the SQL for a vector search. Always emits the canonical `SELECT * FROM [ WHERE ] ORDER BY vector_distance(ARRAY[...]) LIMIT ` shape so the optional `WHERE` clause precedes `ORDER BY` (the SEARCH preprocessor's "trailing append" form would have placed `WHERE` after `ORDER BY`, which is invalid SQL).

(
    collection: &str,
    query: &[f32],
    k: usize,
    filter: Option<&MetadataFilter>,
)

/// preprocessor's "trailing append" form would have placed `WHERE` after
/// `ORDER BY`, which is invalid SQL).
pub(super) fn build_vector_search_sql(
    collection: &str,
    query: &[f32],
    k: usize,
    filter: Option<&MetadataFilter>,
) -> NodeDbResult<String> {
    let collection = quote_identifier(collection);
    let where_clause = match filter {
        Some(f) => format!(" WHERE {}", render_metadata_filter(f)?),
        None => String::new(),
    };
    Ok(format!(
        "SELECT * FROM {collection}{where_clause} ORDER BY vector_distance({}) LIMIT {k}",
        format_vector_array(query),
    ))
}

/// Crate-internal accessor so peer modules (e.g. the field-aware
/// `vector_search_field` override in `client.rs`) can reuse the same