Is there an existing issue for this?

• I have searched the existing issues

Problem statement

Customer code may refer to private python packages not known to compatibility catalog.
These packages may themselves use DB APIs that require pre-migration assessment.

Proposed Solution

Implement a site-packages scanner providing results that can later be used by the DependencyResolver

Additional Context

sub-ticket of #1202