`Error: no such column: unboxes.rarity` with `findMany()`

Hello. I am getting the error Error: no such column: unboxes.rarity despite not using unboxes.rarity

The error comes fron the where in the query below. Is this a bug?

Code:
export const getFilteredUnboxes = async (onlyCoverts?: boolean) =>
  db.query.unboxes.findMany({
    with: {
      item: true,
      case: true,
    },
    where: onlyCoverts
      ? inArray(items.rarity, ["Covert", "Extraordinary"])
      : undefined,
  });


My items schema:
export const items = sqliteTable(
  "items",
  {
    id: text("id").primaryKey().notNull(),
    name: text("name").notNull(),
    description: text("description"),
    image: text("image").notNull(),
    rarity: text("rarity").notNull(),
    phase: text("phase"),
  },
  table => {
    return {
      idxRarity: index("idx_rarity").on(table.rarity),
    };
  },
);
Was this page helpful?