Story

As an admin of RHDH, I want to be able to dynamically load plugins that utilize the database so that I can persist data.

Background

We came across the issue where the logic for dynamic plugins do not support plugins that have migrations folders while trying to add the latest version of @pagerduty/backstage-plugin-backend. 

The issue is that to find the migrations directory, the plugin uses `resolvePackagePath` with the parameter `@pagerduty/backstage-plugin-backend`. What ends up happening is we get the error `ForwardedError: Plugin 'pagerduty' startup failed; caused by Error: Cannot find module '@pagerduty/backstage-plugin-backend/package.json'`. 

Dependencies and Blockers

QE impacted work

Documentation impacted work

Acceptance Criteria

upstream documentation updates (design docs, release notes etc)

Technical enablement / Demo