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

Nessuno ha ancora preso questa issue.

* **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](https://github.com/magicstack/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.

Riproduci il report con asyncpg 0.27.0, PostgreSQL 15.1 e Python 3.10 o 3.11 usando una colonna con DEFAULT NOW() WITH TIME ZONE 'UTC'. Inizia tracciando come quel valore restituito viene convertito in datetime, quindi verifica che il risultato della query conservi tzinfo mentre l'inserimento di aware datetime continui a funzionare.

Scritto dal modello di indicizzazione a partire dal testo della issue.