BlockingIOConnection doesn't support IPV6

[cmr-a]

Describe the bug
BlockingIOConnection throws when you try to connect to an IPv6 address

Reproduction

import edgedb

client = edgedb.create_client(dsn="edgedb://edgedb:edgedb@[::1]:5656/edgedb")
client.ensure_connected()

Produces:

gaierror                                  Traceback (most recent call last)
File [ ~/venv/site-packages/edgedb/blocking_client.py:52], in BlockingIOConnection.connect_addr(self, addr, timeout)
     [57] try:
---> [58]     sock.connect(addr)
     [60]     if not isinstance(addr, str):

gaierror: [Errno -9] Address family for hostname not supported

...

The exception is thrown here:

edgedb-python/edgedb/blocking_client.py

Line 58 in c666a6f

sock.connect(addr)

Expected behavior
Connection established / connection refused

Versions (please complete the following information):

• OS: Linux
• EdgeDB version: N/A
• EdgeDB CLI version: 4.0.2
• edgedb-python version: 1.9.0
• Python version: 3.11.8

Additional context
Other IPv6 addresses produce the same error, nothing special about [::1].

No problems with asyncio_client.

I was able to fix blocking_client.py with:

        if isinstance(addr, str):
            # UNIX socket
            sock = socket.socket(socket.AF_UNIX)
        else:
            if ":" in addr[0]:
                sock = socket.socket(socket.AF_INET6)
            else:
                sock = socket.socket(socket.AF_INET)

I don't know if this is the right way to fix it, but it allowed the connection to be established.

[zachary822]

This new branch should fix the issue. Can you give it a try?

[cmr-a]

It works, thanks!