Return result from JOIN query as object

[MyZik]

Hi! Thanks for awesome work and library. I'm new here and trying to implement the following SQL request. I have two models: Game and User. I want to find all pending games for current user (pending game -> game without enemy) and get the first result. So I want get the Game object, that:

1. Game.currency == chosen currency of user
2. Game.winner_id is None
3. Game host's experience is between 0 and 100

My request:

game = await Game.join(User, User.id == Game.user_id).select().where(
        and_(
            between(User.experience, min_experience, max_experience),
            Game.currency == currency,
            Game.enemy_id == None,
            Game.winner_id == None
        )
    ).gino.first()

But I get the result as list of fields, not as object or dictionary.

I think it should be implemented with Loaders, but I don't have any idea, how can I do right.

Models:
user.py

from __future__ import annotations

from sqlalchemy.sql import expression

from app.models.db import BaseModel, TimedBaseModel, db


class User(TimedBaseModel):
    __tablename__ = "users"

    id = db.Column(db.Integer, primary_key=True, index=True, unique=True)
    ...

class UserRelatedModel(BaseModel):
    __abstract__ = True

    user_id = db.Column(
        db.ForeignKey(f"{User.__tablename__}.id", ondelete="CASCADE", onupdate="CASCADE"),
        nullable=False,
    )

game.py

from __future__ import annotations

from app.models.db import BaseModel, TimedBaseModel, db


class Game(TimedBaseModel):
    __tablename__ = "games"

    id = db.Column(db.Integer, primary_key=True, index=True, unique=True)

    user_id = db.Column(db.Integer, db.ForeignKey('users.id'))
    stock_id = db.Column(db.Integer, db.ForeignKey('stocks.id'))
    enemy_id = db.Column(db.Integer, db.ForeignKey('users.id'))
    enemy_stock_id = db.Column(db.Integer, db.ForeignKey('stocks.id'))
    winner_id = db.Column(db.Integer, db.ForeignKey('users.id'))
    ...


class GameRelatedModel(BaseModel):
    __abstract__ = True

    game_id = db.Column(
        db.ForeignKey(f"{Game.__tablename__}.id", ondelete="CASCADE", onupdate="CASCADE"),
        nullable=False,
    )

db.py

import datetime
from typing import List

import sqlalchemy as sa
from gino import Gino

from app import config

db = Gino()


class BaseModel(db.Model):
    __abstract__ = True

    def __str__(self):
        model = self.__class__.__name__
        table: sa.Table = sa.inspect(self.__class__)
        primary_key_columns: List[sa.Column] = table.primary_key.columns
        values = {
            column.name: getattr(self, self._column_name_map[column.name])
            for column in primary_key_columns
        }
        values_str = " ".join(f"{name}={value!r}" for name, value in values.items())
        return f"<{model} {values_str}>"


class TimedBaseModel(BaseModel):
    __abstract__ = True

    created_at = db.Column(db.DateTime(True), server_default=db.func.now())
    updated_at = db.Column(
        db.DateTime(True),
        default=datetime.datetime.utcnow,
        onupdate=datetime.datetime.utcnow,
        server_default=db.func.now(),
    )
...

Thanks in advance.