Maps a precise primitive type path to its corresponding standard PRIMITIVE_TYPE. Accepts both full paths (e.g. 'meta::pure::precisePrimitives::Varchar') and short names (e.g. 'Varchar'). Returns undefined if the path is not a recognized precise primitive type.