Prisma & CockroachDB - push to array

  await prisma.character.update({
    where: {
      id: connectionId,
    },
    data: {
      [connectionField]: {
        push: characterId,
      },
    },
  });

  const character = await prisma.character.findUnique({
    where: {
      id: connectionId,
    },
  });

  if (character) {
    character[connectionField].push(characterId);

    const updatedCharacter = await prisma.character.update({
      where: {
        id: connectionId,
      },
      data: {
        [connectionField]: character[connectionField],
      },
    });
    return updatedCharacter;
  }