Many-to-Many where in far table

pokemons         pokemonsToType          types
========         ===============         =======
- uuid     <---- - pokemon_uuid     ┌--> - uuid
- name           - type_uuid -------┘    - name

await db.query.pokemons.findMany({
  with: {
    pokemonsToTypes: {
      with: {
        type: { // name of the relation is "type"
          where: (t, { eq }) => eq(t.name, "Water"),
        },
      },
    },
  },
})

{
  uuid: '8766f8d9-d83b-4363-aab2-87431d46bb4e',
  name: 'Venusaur',
  pokemonsToTypes: [
    {
      pokemonUuid: '8766f8d9-d83b-4363-aab2-87431d46bb4e',
      typeUuid: 'ec7b093f-b3c3-4644-9e07-8e0f853ea891',
      type: null
    },
    {
      pokemonUuid: '8766f8d9-d83b-4363-aab2-87431d46bb4e',
      typeUuid: 'ed203404-004a-425f-8b83-20163d5fa54c',
      type: null
    }
  ]
}