Need help with relation

from characters I want 1 row where id = x and specialization = y and include columns from character_scores where id = x and category = z

export const charactersRelations = relations(characters, ({ many }) => ({
  characterScores: many(characterScores),
}));

export const characterScoresRelations = relations(characterScores, ({ one }) => ({
  character: one(characters, {
    fields: [characterScores.characterId],
    references: [characters.id],
  }),
}));

db.query.characters.findMany({
      with: { characterScores: true },
      columns: {
        specialization: true,
        score: true // ! type error, score does not exist
      },
      where: (columns, { and, eq, gt }) =>
        and(
          eq(columns.specialization, specname),
          gt(columns.category, 'foo'), // ! type error, category does not exist
        ),
})