Expose a stream of NoticeResponses from Postgres

[orf]

Is your feature request related to a problem? Please describe.

I'd like to be able to receive a stream of Postgres Notices from a given connection. Ideally this would be done without round-tripping through the tracing/log subsystem.

The specifics of why I need this are somewhat complex, but essentially I'd like to execute SET log_min_messages=debug5, run some queries and collect the log levels that Postgres returns to the client.

Describe the solution you'd like

Some kind of PgListener struct, or stream attached to the connection?

let connection = Connection {...};
let notice_stream = connection.notice_stream()?;
while let Some(notice) = notice_stream.next().await? {
   println!("Got notice: {notice:?}");
}

Describe alternatives you've considered
Unfortunately there are none - I've had to use a lower-level library. Which is really annoying because sqlx is great!

Additional context

From this comment:

sqlx/sqlx-postgres/src/connection/stream.rs

Lines 161 to 163 in 42ce24d

	BackendMessageFormat::NoticeResponse => {
	// do we need this to be more configurable?
	// if you are reading this comment and think so, open an issue