Write integration/E2E tests for node-experimental auto instrumentation #9907

We have a bunch of auto-instrumentation in node-experimental, which uses otel instrumentation under the hood. However, for most of these we do not have any tests yet - mainly because I haven't found a way to test this in integration tests (yet) 😬 Since we want to use these as the main integrations in v8, we should add tests for this. If somebody finds a way to test this in an integration test, that would be great, otherwise we should test them in an E2E test (it is fine to combine these into one or a few E2E test apps, we don't necessarily need a separate E2E test app for each integration).

### Performance Integrations
- [ ] Express - @timfish - ESM with loader still untested/not working
- [x] Fastify
- [x] GraphQL - @onurtemizkan
- [x] Mongo - @timfish
- [x] Mongoose - @timfish
- [x] Mysql - @timfish
- [x] Mysql2 - @timfish
- [x] Postgres - @timfish
- [x] Prisma - @onurtemizkan
- [x] Nest - @onurtemizkan
- [x] Hapi - @timfish
- [x] Http