v3: support new Node typescript support in Node 23.6

[ffMathy]

Clear and concise description of the problem

Node 23.6 released and has removed the experimental stage of typescript support. It's now default and is no longer behind a flag.

Quite crazy that they released it under a minor version.

Suggested solution

But maybe it would be awesome to allow for running the tests directly via that, and maybe it could be faster than doing it via vite-node?

I am a noob at this repo, so I hope what I'm saying makes sense.

Not sure if it could be a breaking change, so maybe it would make sense to ship as part of v3 which is currently in beta.

Alternative

No response

Additional context

No response

Validations

• Follow our Code of Conduct
• Read the Contributing Guidelines.
• Read the docs.
• Check that there isn't already an issue that request the same feature to avoid creating a duplicate.