stdlib matches native pgx scanning support

[jackc]

stdlib can now directly scan into anything pgx can scan such as Go slices.

This requires the change to database/sql implemented by https://github.com/golang/go/pull/67648.

If this PR is accepted it will most likely land in Go 1.24.