Document code of sqlx::query_as has bugs.

[xuehaonan27]

Bug Description

In the document example code of sqlx::query_as, there exists several bugs that I encountered when testing.
query_as.rs: 230 mismatched bracket.
query_as.rs: 230 move TIMESTAMP to TIMESTAMPTZ to match type time::OffsetDateTime.
query_as.rs: 241, 251, 260 move i64 to i32 to match postgres type INT4.

Minimal Reproduction

Just run current code piece in document of query_as:
https://docs.rs/sqlx/latest/sqlx/fn.query_as.html#example-map-rows-using-tuples

Info

• SQLx version: 0.8.2
• SQLx features enabled: "runtime-tokio", "postgres", "time"
• Database server and version: psql (PostgreSQL) 14.13 (Homebrew)
• Operating system: MacOS Sonoma 14.5 23F79
• rustc --version: rustc 1.81.0 (eeb90cda1 2024-09-04)

[benbot]

I believe the Json example using query_as is also incorrect. It looks like macro returns Option<Json<T>> instead of Json<T> and Json<T> doesn't implement From<Option<Json<T>>>

https://docs.rs/sqlx/latest/sqlx/types/struct.Json.html

[xuehaonan27]

I believe the Json example using query_as is also incorrect. It looks like macro returns Option<Json<T>> instead of Json<T> and Json<T> doesn't implement From<Option<Json<T>>>

https://docs.rs/sqlx/latest/sqlx/types/struct.Json.html

I will check it as well! Thank you very much!