Similar building of where clause to Prisma

I'm trying to migrate my prisma queries to drizzle but one thing I'm trying to do is convert the following. I'm lost on how best to 'build' a where clause similar to what prisma has depending on what properties I have passed into my function:

 if (name) {
    whereClause.name = {
      contains: name,
      mode: 'insensitive',
    };
  }
  if (address) {
    whereClause.address = {
      contains: address,
      mode: 'insensitive',
    };
  }
  if (birthday) {
    whereClause.birthday = birthday;
  }
  if (phone) {
    whereClause = {
      ...whereClause,
      OR: [
        {
          phone,
        },
        { alternatePhone: phone },
      ],
    };
  }
  const person = await prisma.person
    .findMany({
      where: whereClause,
    })

 if (name) {
    whereClause.name = {
      contains: name,
      mode: 'insensitive',
    };
  }
  if (address) {
    whereClause.address = {
      contains: address,
      mode: 'insensitive',
    };
  }
  if (birthday) {
    whereClause.birthday = birthday;
  }
  if (phone) {
    whereClause = {
      ...whereClause,
      OR: [
        {
          phone,
        },
        { alternatePhone: phone },
      ],
    };
  }
  const person = await prisma.person
    .findMany({
      where: whereClause,
    })

rphlmr ⚡•9/10/23, 7:40 PM

You can try that:

imobyOP•9/11/23, 12:37 AM

Thanks this helped a lot!!