Partial select

[fruitoiz]

what am I doing wrong? This column exists in the database. Similar code works successfully in Python

code:

let select = chat_user_stat::Entity::find()
    .select_only()
    .column(chat_user_stat::Column::Id)
    .column(chat_user_stat::Column::UserId)
    .column(chat_user_stat::Column::UserName)        
    .column_as(chat_user_stat::Column::MessageAll.sum(), "sum_message")
    .group_by(chat_user_stat::Column::UserId)
    .order_by_desc(chat_user_stat::Column::MessageAll.sum())

let as_a = select.all(&db).await.unwrap();

schema:

//! `SeaORM` Entity. Generated by sea-orm-codegen 0.12.15

use sea_orm::entity::prelude::*;

#[derive(Clone, Debug, PartialEq, DeriveEntityModel, Eq)]
#[sea_orm(table_name = "chat_user_stat")]
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: i32,
    pub chat_id: i64,
    pub user_id: i64,
    #[sea_orm(column_type = "Text")]
    pub user_name: String,
    pub warn: i32,
    pub message: i32,
    pub message_all: i64,
}

#[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]
pub enum Relation {}

impl ActiveModelBehavior for ActiveModel {}

error:

thread 'main' panicked at src/main.rs:176:38:
called `Result::unwrap()` on an `Err` value: Query(SqlxError(ColumnNotFound("chat_id")))
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace

[tyt2y3]

If you are using select only, you'd also need a custom struct https://www.sea-ql.org/SeaORM/docs/next/advanced-query/custom-select/#handling-select-results