query where condition on foreign key relation

export const mapRegions = sqliteTable(
  'map_regions',
  {
    id: integer('id').primaryKey(),
    mapId: integer('map_id')
      .notNull()
      .references(() => maps.id, { onDelete: 'cascade' }),
    regionId: integer('region_id')
      .notNull()
      .references(() => regions.id, { onDelete: 'cascade' })
  },
  (t) => ({
    mapRegionUnique: uniqueIndex('map_region_unique').on(t.mapId, t.regionId)
  })
);

export const mapRegionsRelations = relations(mapRegions, ({ one }) => ({
  map: one(maps, { fields: [mapRegions.mapId], references: [maps.id] }),
  region: one(regions, { fields: [mapRegions.regionId], references: [regions.id] })
}));

await db.query.mapRegions.findMany({
    with: {map: {where: and(eq(maps.isPublished, true), eq(maps.isCommunity, true))}}
  })