Can not disable Prepared statement in SqlX

[groobyming]

Bug Description

When I use sqlx to connect to Doris, I get this error when trying to fetch the result: { source: Database(MySqlDatabaseError { code: Some("HY000"), number: 1105, message: "errCode = 2, detailMessage = Failed to prepare statementtry to set enable_server_side_prepared_statement = true" }) }

Is there a way to disable the "Prepared Statement"?

Minimal Reproduction

let mut con = MySqlConnection::connect("mysql://root:12345@localhost:9030/demo")
            .await.unwrap();
let result = sqlx::query("select * from demo.mytable limit 10").fetch(&mut con);
println!("result is {:?}", result)

Info

• SQLx version: [0.7.4]
• SQLx features enabled: ["runtime-tokio-rustls", "macros", "chrono", "mysql"]
• Database server and version: [REQUIRED] (Apache Doris)
• Operating system: [Linux X86_64]
• rustc --version: [rustc 1.79.0-nightly]

[abonander]

You can execute SQL without using a prepared statement with sqlx::raw_sql(). The rest of SQLx is designed heavily around prepared statements.