Specify output for query_as!

[Burny-McBurnFace]

How can I specify the output type of a query_as! call? When using the non-macro query, I can row.get("mydatetime") into a NaiveDateTime just fine, but I'm unsure how to specify the record output type with the macro version.

[Burny-McBurnFace]

This also occurs with something like expecting a bool but getting a tinyint when specifying a struct.

[abonander]

query_as! supports the same type override syntax as query!: https://docs.rs/sqlx/latest/sqlx/macro.query.html#type-overrides-output-columns

You can also use foo as "foo: _" to have the type inferred from the corresponding field in the struct (it'll still be checked for compatibility at runtime).