advanced relational query builder

hey, i have a use case where i need to return rows from one table based on filters requiring on connected table

here's prisma equivalent code

await prisma.card.findMany({
  where: {
    // character is another table
    character: {
      element: '...'
    }
  }
})

await prisma.card.findMany({
  where: {
    // character is another table
    character: {
      element: '...'
    }
  }
})

await prisma.card.findMany({
  where: {
    // character is another table
    character: {
      element: '...'
    }
  }
})

await prisma.card.findMany({
  where: {
    // character is another table
    character: {
      element: '...'
    }
  }
})

how would this be possible with drizzle