#[derive(Clone, Debug, PartialEq, DeriveEntityModel, Serialize, Deserialize, ToSchema)]
#[sea_orm(table_name = "project")]
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: i32,
    pub name: String,
}
#[derive(Serialize, Debug, ToSchema, DerivePartialModel)]
#[serde(rename_all = "camelCase")]
#[sea_orm(entity = "Entity", from_query_result)]
pub struct ProjectExport {
    pub id: i32,
    pub name: String,
    
    // https://github.com/SeaQL/sea-orm/discussions/2534
    #[sea_orm(nested)]
    pub seller: Option<SellerExport>,

    pub total_amount: Option<f32>,
}

Project::find()
    .left_join(Seller)
    .left_join(Interval)
    .column_as(
        Expr::col(interval::Column::Amount).sum(),
        "total_amount",
    )
    .group_by(project::Column::Id)
    .group_by(seller::Column::Id)
    .into_partial_model::<ProjectExport>()
    .all(get_connection(depot)?).await?;