Use of skip or default with query_as! macro?

[CalebCurry]

Hi there,
I want a struct to allow for nested data, but the field doesn't exist in the database. I can't seem to use #[sqlx(skip)] and ignore that field with query_as!.
I have read through the docs and FAQ, but am not finding anything.

is there a way to tell sqlx that the field is not expected to be in the database?

pub struct Dashboard {
    pub id: i32,
    pub title: String,
    pub created_by_id: String,
    pub public: bool,
    pub created_at: chrono::NaiveDateTime,
    #[sqlx(skip)] // to be filled in later with another query
    pub widgets: Vec<Widget>,
}

...

let dashboard = sqlx::query_as!(Dashboard, "SELECT * FROM dashboard WHERE id = $1", id)
    .fetch_one(&pool)
    .await
    .expect("Failed to execute query");

This gives me:

`missing field `widgets` in initializer of `controllers::dashboard::Dashboard`
missing `widgets`

I still want the benefit of static checking, but would like to avoid creating duplicate types with slight variations. As a workaround I have created 2 structs. One as the database response type without the additional field, which I then copy over to the 2nd type which does have that field.

I'm new to sqlx so any suggestions on best practices would be appreciated.

[glyndwr-io]

I'm also running into this issue, I have a hunch that it may have to do with the order in which the macros run. Commenting here to follow the issue and will report back if I find something.

EDIT: just found this. It looks like currently the query_as! macro doesn't use the FromRow implementation. (#514)

[nabiu256]

Have you found any workaround that doesn't imply creating a second, slightly different struct? I just ran into this same problem.

[glyndwr-io]

I did not unfortunately but the project this was for has been temporarily shelved so it's been a while since I last looked at it. We decided that the de-serialization into a struct was more important than compile time query checking and opted to use the query_as function instead of the macro.

[nicosuave]

I would appreciate this too!