Trying to use the SQLX forced nullability and non nullability syntax.

[hyperliskdev]

pub struct Location {
    id: Uuid,
    title: String,
    parent: Option<i32>,
}



pub async fn query_locations(pool: &PgPool) -> Result<Vec<Location>, Error> {


    let query = sqlx::query_as!(Location, r#" SELECT * FROM locations "#)

;
    query
}

In a project I am working on i want to use UUIDs for the id of the data. The parent member of the Location struct is looking for i32 from sqlx. I want to use the Option<Uuid> but i get an error about mismatched types.

I took a look at the referenced documentation here

How can use the Option<uuid> on the Location? Do i need to implement something on the type or create a custom parent type?

[hyperliskdev]

According to the macro documentation, I should be able to do SELECT id, title, "parent?: Uuid" FROM locations but the "parent?: Uuid " column doesnt exist?