Python - Документация

(VotingAchievement.uuid == nomination_id) if nomination_id else True
~ VotingAchievement.uuid

nominations = await self._session.execute(
            select(VotingAchievement).where(
                ~VotingAchievement.is_deleted,
                VotingAchievement.is_published,
                (VotingAchievement.uuid == nomination_id) if nomination_id else True,
            ).order_by(VotingAchievement.position).options(
                selectinload(VotingAchievement.icon), selectinload(VotingAchievement.preview)
            )
        )
 
for nomination in nominations.scalars().all():
  ...

result = []
for nomination in nominations.scalars().all():
  query = select(
    ExponentVotesAggregation.uuid,
    ExponentVotesAggregation.title_ru,
    ExponentVotesAggregation.title_en,
    func.sum(ExponentVotesAggregation.count).label("count")
  ).where(
    ExponentVotesAggregation.created_at >= since,
    ExponentVotesAggregation.created_at <= till,
    ExponentVotesAggregation.nomination_id == nomination.uuid,
  ).group_by(
    ExponentVotesAggregation.uuid,
    ExponentVotesAggregation.title_ru,
    ExponentVotesAggregation.title_en,
  ).order_by(desc(text("count")))
 
  exponents = await self._session.execute(
    query
  )
 
  result.append((nomination, exponents.all(),))