THere is a resolved symlinks view which we can use for this and maybe that solves more of our problems them we imagine.
This would be cr_resolved_items. CMS is the only package that uses this view right now...