use sqlx::{prelude::FromRow, Connection, SqliteConnection};

const DATABASE_URL: &str = "./mydb/sqlite";

#[derive(Debug, FromRow)]
#[sqlx(rename_all = "UPPERCASE")]
pub struct ObjInfo {
    pub name: String,
}

pub async fn get_info(name: &str) -> Result<ObjInfo, Box<dyn std::error::Error>> {
    let mut conn = SqliteConnection::connect(DATABASE_URL).await?;
    let param =  format!("{}%", name);
    let record = sqlx::query!("SELECT MYNAME FROM mytable WHERE MYNAME = ?", param)
        .fetch_one(&mut conn)
        .await?;

    Ok(ObjInfo {
        name: record.MYNAME.unwrap_or_default()
    })
}

Field `MYNAME` should have snake_case name, e.g. `myname`
Variable `sqlx_query_as_NAME` should have snake_case name, e.g. `sqlx_query_as_name`