Is there any API to conver any database query row results to the serde_json::Value result?

[TQLeung]

Is there any API to conver any database query row results to the serde_json::Value result?

likes function:
execute SQL statement

select 1 as i, current_timestamp as ct, stu.name, stu.age from stu limit 2

can CONVERT to serde_json::Value

[
  {
       "i":1,
       "ct": "2024-06-04T10:00:46",
       "name": "jack",
       "age": 20
  },
  {
       "i":1,
       "ct": "2024-06-04T10:00:46",
       "name": "lily",
       "age": 16
  },
]

[doveq]

I'm doing from https://stackoverflow.com/questions/77029413/getting-column-data-using-sqlx-with-rust, is there a better way?

let rows = sqlx::query("SELECT * FROM comments limit 2")
        .fetch_all(&*DB)
        .await?;

    let mut res = vec![];
    for row in rows {
        let mut jv = serde_json::json!({});
        for col in row.columns().iter() {
            let name = col.name();
            let ordinal = col.ordinal();
            let type_name = col.type_info().name();

            let v = match type_name {
                "TEXT" => serde_json::json!(row.get::<String, _>(ordinal)),
                "INTEGER" => serde_json::json!(row.get::<i64, _>(ordinal)),
                "BOOLEAN" => serde_json::json!(row.get::<bool, _>(ordinal)),
                "REAL" => serde_json::json!(row.get::<f64, _>(ordinal)),
                // probably missed a few other types?
                _ => {
                    serde_json::json!(format!("UNPROCESSED TYPE '{}'", type_name))
                }
            };

            jv[name] = v;
        }

        res.push(jv);
    }

    println!("{:?}", res);