feat(node): Support IPv6 as DSN (#2996)

[xgedev]

Setting an IPv6 URL as a DSN does not work, see #2996. This updates the DSN_REGEX to correctly match IPv6 and fixes the then occuring issue that the brackets "[" and "]" are in the request's hostname and prevent the request from being made.

[Lms24]

I asked internally if there are concerns with adding support

No concerns, so we'll merge this in eventually 👍

@xgedev please let me know if you want to continue working on this or if we should take over, thanks!