ESM support, stage 2

[trentm]

#1952 will add initial experimental ESM support. This issue lists a number of follow tasks for ESM support:

• node v20 support (there is an IITM update with support): feat: enable ESM support for Node v20 #3469
• work through remaining modules:
  • lambda functions
  • azure functions
  • @apollo/server
  • @elastic/elasticsearch
  • @opentelemetry/api
  • @opentelemetry/sdk-metrics
  • apollo-server-core
  • aws-sdk
  • bluebird
  • cassandra-driver
  • elasticsearch
  • express-graphql
  • express-queue
  • finalhandler
  • generic-pool
  • graphql
  • handlebars
  • hapi, @hapi/hapi
  • http2
  • jade
  • koa
  • koa-router, @koa/router
  • memcached
  • mimic-response
  • mongodb-core
  • mongodb
  • mysql
  • mysql2
  • next
  • pug
  • redis
  • restify
  • tedious
  • undici
  • ws
• elastic-apm-node/start cannot load config with type 'module' #1612
• revisit the "starting the agent" docs now that there is some ESM support. Might want to start preferring the option of using the node CLI options rather than starting in code.
• Lambda support for .mjs files (see getFilePath in "lib/lambda.js")

[Zorinik]

Good morning, is there an ETA for this?
I have a whole software platform using Hapi & Node 20, and I have been waiting since last year for APM to support it :) at the moment I had to to totally disable APM for the current year. Is it actively being worked on?

[curtdept]

@trentm id happily instrument lambda manually if it meant I could move to ESM.

Even a function like this https://github.com/newrelic/newrelic-lambda-layers?tab=readme-ov-file#manual-instrumentation-for-es-modules would be very helpful until a more auto shim could be found

Honestly manual shims should be a thing in APM and would give us more better control as a developer and allow you guys to be less constrained to the major downsides of auto shimming. Especially in the context of bundling, etc.