how to map a rust enum to an sql varchar type in postgres?

[maku]

e.g. I have a simple enum in rust

#[derive(Debug, Serialize, Deserialize, Clone, PartialEq)]
pub enum TradeType {
Buy,
Sell,
}

pub struct Trade {
pub trade_type: TradeType
}

What can I do to map this struct to a table where trade_type is defined as VARCHAR

Currently I get compilation errors e.g. (expected enum '...', found struct std::string::String) when using macros like sqlx::query_as!

How do I find such topics in docs?

[jplatte]

I believe this is what you are looking for:

• https://docs.rs/sqlx/latest/sqlx/macro.query.html#force-a-differentcustom-type
• https://docs.rs/sqlx/latest/sqlx/macro.query_as.html#column-type-override-infer-from-struct-field

[szg251]

Is there a way to do a type override for INSERT queries. This obviously doesn't work:

r#"INSERT INTO my_table (id, my_type as "my_type: SubscriptionType") VALUES ($1,$2)"#

I know I can convert my_type to a string when I am applying it to the query macro, but I'd prefer to reuse the same mechanism.