Querying JSON from Postgres DB

[ChaseLewis]

I'm wanting to put what should be a small json blob that defines a dataset schema into my database. The issue is when I do this I get the following error.

expected struct `sqlx::types::Json`, found enum `JsonValue`

Failing Code

#[derive(sqlx::FromRow, Serialize, Deserialize, Debug, Clone)]
pub struct Dataset{
    #[serde(rename = "datasetId")]
    pub dataset_id: Uuid,
    #[serde(rename = "name")]
    pub dataset_name: String,
    #[serde(rename = "schema")]
    pub dataset_schema: Json<DatasetSchema>,
    #[serde(rename = "createdAt")]
    pub created_at: DateTime<Utc>
}

pub async fn get_dataset(ctx: &sqlx::PgPool, dataset_id: Uuid) -> Result<Option<Dataset>,sqlx::Error> {
    let dataset = sqlx::query_as!(Dataset, "SELECT * FROM datasets WHERE dataset_id = $1", dataset_id)
    .fetch_optional(ctx)
    .await?;

    return Ok(dataset); 
}

Working Code

#[derive(sqlx::FromRow, Serialize, Deserialize, Debug, Clone)]
pub struct Dataset{
    #[serde(rename = "datasetId")]
    pub dataset_id: Uuid,
    #[serde(rename = "name")]
    pub dataset_name: String,
    #[serde(rename = "schema")]
    pub dataset_schema: Json<DatasetSchema>,
    #[serde(rename = "createdAt")]
    pub created_at: DateTime<Utc>
}


pub async fn get_dataset(ctx: &sqlx::PgPool, dataset_id: Uuid) -> Result<Option<Dataset>,sqlx::Error> {
    let dataset = sqlx::query_as!(Dataset, r#"SELECT 
    dataset_id, 
    dataset_name, 
    dataset_schema as "dataset_schema!: sqlx::types::Json<DatasetSchema>",
    created_at 
    FROM datasets WHERE dataset_id = $1"#, dataset_id)
    .fetch_optional(ctx)
    .await?;

    return Ok(dataset); 
}

Is there a way to coerce the value without having to write out every field in the struct? Since it requires a literal I can't even simplify the code with concat! which means using the json fields adds an annoying amount of query complexity.