option to not use prepared statements

[vidmartin]

I want to create a trigger in a MySQL server using SQLx. However, I get this error:

1295 (HY000): This command is not supported in the prepared statement protocol yet

I looked into SQLx source code and it seems that SQLx always creates a prepared statement for any query I execute. However, there are likely many valid statements, that cannot be made into prepared statements, like this one. Could we get an option to disable using prepared statements?

I think that if a query has no parameters and persistent is turned off, it shouldn't create a prepared statement. I think this would be quite easy to implement into SQLx.

Is there a simple way I can get around this for now?

[abonander]

If you invoke the methods of Executor directly with a query string, it will not use prepared statements: https://docs.rs/sqlx/latest/sqlx/trait.Executor.html