Support for synchronous hooks

[raphael-theriault-swi]

With Node 26 freshly released and both --experimental-loader and module.register deprecated, it's probably a good time to start thinking about supporting synchronous module hooks in IITM (and RITM !!). Could it also make sense to maybe merge both into a unified API now that the underlying mechanism can be made the same ?

Sorry if this is already tracked somewhere else and I couldn't find it.

[jsumners-nr]

I'm sure we'd consider a PR, or multiple, that target this issue. But I believe most APM vendors are moving toward using https://github.com/nodejs/orchestrion-js. While this module was designed to solve observability problems with ESM, there are fundamental issues with ESM that the approach of this tool just cannot overcome.

[timfish]

The new registerHooks API hooks for both require and import. That means it potentially replaces require-in-the-middle too so I don't think this is a basic "use the new API" migration for import-in-the-middle. The ecosystem currently uses two libraries to hook both require and import!