build(deps): update asyncpg requirement from <0.28,>=0.20 to >=0.20,<0.30

[dependabot[bot]]

Updates the requirements on asyncpg to permit the latest version.

Release notes

Sourced from asyncpg's releases.

v0.29.0

Minor fixes and improvements.

Improvements

• Python 3.12 and PostgreSQL 16 support (#1084) (by @​elprans in deea86ce)

• Add support for tuple-format custom codecs on composite types (#1061) (by @​elprans in 922fcd10)

• Support target_session_attrs in URL format, add tests (#1073) (by @​elprans in 7cb4e70d)

• Infinity numeric support (#1067) (by @​krokoziabla in 0c3bf600 for #1020)

• Add support for the WHERE clause in copy_to methods (#941) (by @​kaylynn234 in b7ffab6c)

• Add query logging callbacks and context manager (#1043) (by @​dcwatson in b2697ffd)

Fixes

• When prepared statements are disabled, avoid relying on them harder (#1065) (by @​elprans in cbf64e18)

• Handle environments with HOME set to a not-a-directory (#1063) (by @​elprans in af922bcf)

• Fix handling of non-ASCII passwords (#1062) (by @​elprans in 89d5bd03)

• Disable JIT while doing type introspection (#1082) (by @​elprans in f21ebf64)

• Remove connection parameter caching in Pool (#1053) (by @​ermakov-oleg in 4ddb0397)

• Switch to Python 3.12-style wait_for (#1086) (by @​elprans in 4bdd8a7e)

• Update automatic PostGIS type conversion for Shapely 2.0 (#1085) (by @​ChimneySwift in 8b45beb4)

• Use the timeout context manager in the connection path (#1087) (by @​elprans in 313b2b2b)

... (truncated)

Commits

• 74f3a00 asyncpg v0.29.0
• d7faaff fix: allow host tuple (#1021)
• b2697ff Add query logging callbacks and context manager (#1043)
• 93a6f79 Cut BaseProtocol circular reference on close. (#1049)
• ca9f03b Close cursor portals once the iterator is exhausted (#1088)
• b7ffab6 Add support for the WHERE clause in copy_to methods (#941)
• 70c8bd8 Use cleanup_ctx in pool usage doc (#878)
• ccc7baf Small fix for documentation on using SSL in Connection (#995)
• 313b2b2 Use the timeout context manager in the connection path (#1087)
• 8b45beb Update automatic PostGIS type conversion for Shapely 2.0 (#1085)
• Additional commits viewable in compare view

You can trigger a rebase of this PR by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Note Automatic rebases have been disabled on this pull request as it has been open for over 30 days.

[tulir]

@dependabot rebase