how to do nested join

[mithun2003]

 request_alias = aliased(request_model)
    user_alias = aliased(user_model)

    # Subquery to get the latest request for each user
    latest_request_subquery = (
        select(
            request_alias.user_id, 
            func.max(request_alias.created_at).label('latest_created_at')
        )
        .group_by(request_alias.user_id)
        .subquery()
    )

    # Subquery to get the highest score for each user
    highest_score_subquery = (
        select(
            user_alias.user_id,
            func.max(user_alias.score).label('highest_score')
        )
        .group_by(user_alias.user_id)
        .subquery()
    )

    # Join the latest request subquery and highest score subquery with the main stmt
    stmt = stmt.join(
        latest_request_subquery,
        (request_model.user_id == latest_request_subquery.c.user_id) &
        (request_model.created_at == latest_request_subquery.c.latest_created_at),
    ).join(
        highest_score_subquery,
        user_model.user_id == highest_score_subquery.c.user_id
    ).filter(
        user_model.score == highest_score_subquery.c.highest_score
    )

i have a query like this; i can run it in get_multi_joined

[igorbenav]

Currently you can't. You can always create a custom CRUD class inheriting from FastCRUD and use method chaining to define this custom query as a method.