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.

Reproduce el informe con asyncpg 0.27.0, PostgreSQL 15.1 y Python 3.10 o 3.11 usando una columna con DEFAULT NOW() WITH TIME ZONE 'UTC'. Empieza rastreando cómo se convierte ese valor devuelto a datetime y, después, verifica que el resultado de la consulta conserve tzinfo mientras la inserción de aware datetime siga funcionando.