How to load Entity with record linked Entity ?

[ronanM]

For the exemple: Person ----record-link----> Dog.

#[derive(Debug, Serialize, Deserialize)]
struct Person {
    name: String,
    fname: String,
    dog: Thing,
}

#[derive(Debug, Serialize, Deserialize)]
struct Dog {
    name: String,
    age: u8,
}

#[derive(Debug, Deserialize)]
struct PersonWithDog {
    a_person: Person,
    a_dog: Dog,
}

#[derive(Debug, Deserialize)]
struct CreatedId {
    #[allow(dead_code)]
    id: Thing,
}

Creations:

    db.query(
        r#"
            REMOVE TABLE dog;
            REMOVE TABLE person;

            DEFINE TABLE dog    SCHEMAFULL;
            DEFINE FIELD name   ON TABLE dog TYPE string;
            DEFINE FIELD age    ON TABLE dog TYPE int;

            DEFINE TABLE person SCHEMAFULL;
            DEFINE FIELD name   ON TABLE person TYPE string;
            DEFINE FIELD fname  ON TABLE person TYPE string;
            DEFINE FIELD dog    ON TABLE person TYPE record(dog);
        "#,
    )
    .await?;

    let dog = Dog {
        name: "rex".into(),
        age: 3,
    };
    let created_dog_id: Vec<CreatedId> = db.create("dog").content(dog).await?;
    let created_dog_id: Thing = created_dog_id.first().expect("No created dog").id.clone();

    let person = Person {
        name: "name".into(),
        fname: "first name".into(),
        dog: created_dog_id,
    };
    let _: Vec<CreatedId> = db.create("person").content(person).await?;

Select Person with linked Dog:

    let mut person_with_dog_response: Response = db
        .query("SELECT {name:name, fname:fname, dog:dog} AS a_person, dog.* AS a_dog FROM person")
        //            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
        .await?;

    let person_with_dog: Vec<PersonWithDog> =
        person_with_dog_response.take::<Vec<PersonWithDog>>(0)?;
    dbg!(&person_with_dog);

Output:

[src/bin/main.rs:90:5] &person_with_dog = [
    PersonWithDog {
        a_person: Person {
            name: "name",
            fname: "first name",
            dog: Thing {
                tb: "dog",
                id: String(
                    "krqkrun7r2imsdmue3yf",
                ),
            },
        },
        a_dog: Dog {
            name: "rex",
            age: 3,
        },
    },
]

What is the idiomatic/nicer way to do this ?