PgStac no longer works with Azure Flexible Postgres server

[martys]

• asyncpg version: 0.28.0
• PostgreSQL version: 13.12
• Do you use a PostgreSQL SaaS? If so, which? Can you reproduce
  the issue with a local PostgreSQL install?: Yes, works locally.
• Python version:3.10
• Platform:Windows
• Do you use pgbouncer?:No
• Did you install asyncpg with pip?:yes
• If you built asyncpg locally, which version of Cython did you use?:N/A
• Can the issue be reproduced under both asyncio and
  uvloop?:Don't know

A few days ago Microsoft has bumped up a minor version of a "Azure Database for PostgreSQL flexible server" to version 13.12 from 13.11

After that - all PGstac methods using that are utilized by Stac-Fast-Api stopped working !
resulting in a "segmentation fault" and not returning any data back.

Executing the same queries or stored procedures using a PGAdmin works fine, indicating a problem with pgstab library

We are in the middle of production outage right now due to this, and will add more details as they become available.

After deeper investigation we see that the issue is coming from asyncpg library

packages/asyncpg/connection.py", line 1366, in reset
    await self.execute(reset_query, timeout=timeout)
  File "/home/mantasmantas/projects/Atlas-Platform/app/atlas_ui/stac_fastapi/venv/lib/python3.10/site-packages/asyncpg/connection.py", line 317, in execute
    return await self._protocol.query(query, timeout)
  File "asyncpg/protocol/protocol.pyx", line 338, in query
asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in the middle of operation