DEFAULT NOW() WITH TIME ZONE 'UTC' is getting ignored, thus returning a naive datetime when queried.

• asyncpg version: 0.27.0
• PostgreSQL version: 15.1
• Do you use a PostgreSQL SaaS? If so, which? Can you reproduce
  the issue with a local PostgreSQL install?: No
• Python version: 3.11.1 and 3.10.1
• Platform: Windows 11 or PC
• Do you use pgbouncer?: No
• Did you install asyncpg with pip?: Yes
• If you built asyncpg locally, which version of Cython did you use?: No
• Can the issue be reproduced under both asyncio and
  uvloop?: Probably, never tried.

DEFAULT NOW() WITH TIME ZONE 'UTC' is not getting parsed to datetime.datetime with tzinfo. It basically ignores the tzinfo and returns a naive datetime when queried. Inserting an aware datetime is fine though.

Reproduza o relato com asyncpg 0.27.0, PostgreSQL 15.1 e Python 3.10 ou 3.11 usando uma coluna com DEFAULT NOW() WITH TIME ZONE 'UTC'. Comece rastreando como esse valor retornado é convertido para datetime e, em seguida, verifique se o resultado consultado mantém tzinfo enquanto a inserção de aware datetime continua funcionando.