you can try Rbatis 4.6 - High-Performance Rust ORM Framework Upgrade
this is allow python like query ORM(see doc).
just like example:
pub struct User{
pub delete_flag:i32,
pub name:String
}
#[py_sql(
"`select * from user where delete_flag = 0`
if name != '':
` and name=#{name}`"
)]
async fn py_select(rb: & dyn Executor, name: &str) -> Result<Vec<User>, Error> {
impled!()
}