Get the predicate mapping for a relationship type. Handles both UPPER_SNAKE_CASE and camelCase input.