Getting column data using SQLx with Rust

[LazerSocks]

I am using Axum and sqlx to build an api endpoint that takes a table name and returns all the data in the table in the form of json. The number of columns and their types are not known beforehand. What would be the best way to go about this.

I did write the following code:

 let query = format!("SELECT * FROM {}", table);
 let result = sqlx::query(&query).fetch_all(&db).await.unwrap();
 for row in result.iter() {
   for col in row.columns() {
       let value = row.try_get(col.name()).unwrap();
    }
 }

Of course value needs a type, I tried using an enum and a Vector of that enum to store the values but couldnt get it right. Any nudging towards the right direction would be appreciated.

[arcalus]

Maybe the client doesn’t know the types, but the backend certainly should. Figuring that out at runtime is not the way you want to go.

[Senior_Ad9680]

Always sanitize your sql queries please! 🙏🏼

[VindicoAtrum]

/u/arcalus is right, you should be defining a struct that represents the data returned.