query_as! macro does not work with rename_all = "camelCase"

[Niels-Be]

Bug Description

query_as! macro does not work with rename_all = "camelCase"

Minimal Reproduction

#[derive(Debug, FromRow, Clone)]
#[sqlx(rename_all = "camelCase")]
struct Model {
  pub some_name: String;
}

// CREATE TABLE ModelTable ( someName TEXT NOT NULL );

sqlx::query_as!(Model, "SELECT * FROM ModelTable").fetch_all(&pool);
// Error: struct `Model` has no field named `someName`
//  help: a field with a similar name exists: `some_name`

While the error message is technically correct, just using query_as without the macro works fine as expected.

Info

• SQLx version: 0.6.3
• SQLx features enabled: runtime-tokio-rustls, sqlite
• Database server and version: sqlite3
• Operating system: linux
• rustc --version: rustc 1.72.0-nightly (46514218f 2023-06-20)

[abonander]

query_as! is not currently aware of the FromRow derive. See the docs: https://docs.rs/sqlx/latest/sqlx/macro.query_as.html

This macro does not use FromRow; in fact, no trait implementations are required at all, though this may change in future versions.

#514 for details.