[instrumentation-mongoose] add support for mongoose@9

[trentm]

mongoose@9 was released relatively recently:

$ npm info mongoose time
...
  '8.20.1': '2025-11-20T20:46:15.168Z',
  '9.0.0': '2025-11-21T15:58:59.442Z',
  '7.8.8': '2025-12-05T01:48:30.094Z',
  '8.20.2': '2025-12-05T16:29:19.182Z',
  '9.0.1': '2025-12-05T17:49:48.729Z'

The instrumentation will need an update to support instrumenting mongoose@9.

Related:

• the PR from a while back that added mongoose@8 support: feat(instrumentation-mongoose): Support v7 and v8 #2353
• an issue to update instr-mongodb to support mongodb@7 (which mongoose@8 uses): [instrumentation-mongodb]: add support for v7 #3262

[Farhan-Abbas]

I'd like to work on this.

[david-luna]

Thanks @Farhan-Abbas. I've assigned you to this issue