fix(uri-parsing): handle password with bracket in connection url

[grieve54706]

Description of changes

If the password is with a bracket in the connection url, urllib.parse.urlparse(url) will raise the error ValueError: Invalid IPv6 URL in backends.connect(). But if the caller quotes the password to avoid parsing failing, ibis does not unquote back the password.

Reproducible example

import ibis
import pytest

invalid_password = "invalid_password["
with pytest.raises(ValueError) as e:
    ibis.connect(f"postgres://username:{invalid_password}@localhost:5432/dbname")
assert str(e.value) == "Invalid IPv6 URL"

[gforsyth]

Thanks for putting this in @grieve54706 !

I marked a few spots that are causing the CI failures

[gforsyth]

I think most of the CI failures stem from this import, which should be from urllib.parse

[gforsyth]

the password attribute can be None depending on the connection string, so there needs to be a None check before calling unquote_plus

[grieve54706]

@gforsyth Thanks for your suggestion. You saved my life.

[cpcloud]

LGTM, I'll do a few cleanups of the excepting string matching in #9482

[cpcloud]

@grieve54706 @gforsyth Is there a corresponding issue for this PR? NBD if not, just wondering!

[gforsyth]

I don't think there was

[grieve54706]

Nope. Thank you for your time.