Function parse_file_stem 

pub(crate) fn parse_file_stem(stem: &str) -> (&str, Option<&str>)

Split a file stem into (object_name, optional_profile).

Uses rsplit_once('#') so that pg_conn#staging → ("pg_conn", Some("staging")). Returns (stem, None) if no valid split exists (empty parts).