bug: Plugins fail to load in monorepo

[EinfachHans]

I'm submitting a...

• Bug report
• Feature request
• Question

Current behavior

I have a npm monorepo like:

- packages/
  - backend/
    - package.json
 - package.json 

The backend project contains all the pg-migrate stuff.
Npm defaultly installs all node_modules into the root project and only duplicates into the single project folders.

This makes the load of plugin fail if pg-migrate is started from within the backend project, because of this line:

node-db-migrate/index.js

Line 48 in 6acaf40

var plugin = require(path.join(options.cwd, 'node_modules', plugins[i]));

Expected behavior

It should work in a monorepo context as well. Maybe by recursively looking into the node_modules folder until reached the root of the project.

Environment

db-migrate version: 0.11.14
plugins with versions: db-migrate-plugin-typescript (2.0.0)
db-migrate driver with versions: pg (1.5.2)

Additional information:
- Node version: 20.9.0
- Platform: Mac