Simplifying Data Extraction from Complex Query Results

[FeehGb]

I'm trying to extract data from a query that returns the following lines. I'm using SQLAlchemy, and my model returns this way because I'm doing select(Model) and appending some CTE.

Row: ((Model), int, int, int, bool). To extract the values, I'm using this Pydantic class:

class PriceResearchListBaseSchema(APIModel):
    descricao: str
    tipo_pesquisa: EnumResearchType
    frequencia: int | None
    dias_arr: list[int] | None = []
    recorrencia: EnumRecurrence | None
    dt_inicio: date | None
    dt_pesquisa: date | None
    dt_ult_geracao: date | None
    dt_proxima_coleta: date | None
    fl_ativo: bool

class PriceResearchListSchema(PriceResearchListBaseSchema):
    id: int
    codigo: int
    descricao_recorrencia: str | None
    concorrentes: list[PriceResearchListCompetitorSchema] = Field(...)

class PriceResearchListMetricsResponseSchema(APIModel):
    lista_pesquisa_preco: PriceResearchListSchema
    qtd_concorrente: int
    qtd_cluster: int
    qtd_familia: int
    qtd_familia_replicada: int
    qtd_familia_nao_encontrada: int
    qtd_familia_inativa: int
    fl_todas_familias_replicada: bool

Following this, I got this result:

{
    "listaPesquisaPreco": {
        "descricao": "BAZAR",
        "tipoPesquisa": "Recorrente",
        "frequencia": null,
        "diasArr": [],
        "recorrencia": null,
        "dtInicio": "2022-09-13",
        "dtPesquisa": null,
        "dtUltGeracao": null,
        "dtProximaColeta": null,
        "flAtivo": true,
        "id": 402,
        "codigo": 170,
        "descricaoRecorrencia": null,
        "concorrentes": [
            {"id": 1163, "concorrenteId": 4, "concorrenteCodigo": 3065, "concorrenteDescricao": "FORT BALNEARIO CAMBORIU"},
            {"id": 408, "concorrenteId": 6, "concorrenteCodigo": 168282, "concorrenteDescricao": "FORT PORTO BELO"}
        ]
    },
    "qtdConcorrente": 2,
    "qtdCluster": 3,
    "qtdFamilia": 40,
    "qtdFamiliaReplicada": 0,
    "qtdFamiliaNaoEncontrada": 0,
    "qtdFamiliaInativa": 15,
    "flTodasFamiliasReplicada": false
}

I would like this result:

{
    "descricao": "BAZAR",
    "tipoPesquisa": "Recorrente",
    "frequencia": null,
    "diasArr": [],
    "recorrencia": null,
    "dtInicio": "2022-09-13",
    "dtPesquisa": null,
    "dtUltGeracao": null,
    "dtProximaColeta": null,
    "flAtivo": true,
    "id": 402,
    "codigo": 170,
    "descricaoRecorrencia": null,
    "concorrentes": [
        {"id": 1163, "concorrenteId": 4, "concorrenteCodigo": 3065, "concorrenteDescricao": "FORT BALNEARIO CAMBORIU"},
        {"id": 408, "concorrenteId": 6, "concorrenteCodigo": 168282, "concorrenteDescricao": "FORT PORTO BELO"}
    ],
    "qtdConcorrente": 2,
    "qtdCluster": 3,
    "qtdFamilia": 40,
    "qtdFamiliaReplicada": 0,
    "qtdFamiliaNaoEncontrada": 0,
    "qtdFamiliaInativa": 15,
    "flTodasFamiliasReplicada": false
}

Is there a way to achieve this?