/**
   * Updates user names to the pattern user_%uid.
   *
   * It's only been tested on MySQL.
   */
  protected function sanitizeUserNames(): void {
    try {
      [$name_table, $name_column] = $this->getFieldTableDetails('user', 'name');
      [$uid_table, $uid_column] = $this->getFieldTableDetails('user', 'uid');
      assert($uid_table === $name_table);
      $this->database->update($name_table)
        ->condition($uid_column, 0, '>')
        ->expression($name_column, "CONCAT('user_', $uid_column)")
        ->execute();
      $this->logger()->success(dt("User names sanitized."));
    }
    catch (\Exception $e) {
      $context = ['@message' => $e->getMessage()];
      $this->logger()->error(dt("Unable to sanitize user names: @message.", $context));
    }
  }

  /**
   * Gets database details for a given field.
   *
   * It returns the field table name and main property column name.
   *
   * @param string $entity_type_id
   *   The entity type ID the field's attached to.
   * @param string $field_name
   *   The field name.
   *
   * @return array
   *   An indexed array, containing:
   *   - the table name;
   *   - the column name.
   */
  protected function getFieldTableDetails(string $entity_type_id, string $field_name): array {
    $storage = $this->entityTypeManager->getStorage($entity_type_id);
    if (!$storage instanceof SqlEntityStorageInterface) {
      $context = ['!entity_type_id' => $entity_type_id];
      throw new \Exception(dt("Unable to get !entity_type_id table mapping details, its storage doesn't implement \Drupal\Core\Entity\Sql\SqlEntityStorageInterface.", $context));
    }
    $mapping = $storage->getTableMapping();
    $table = $mapping->getFieldTableName($field_name);
    $columns = $mapping->getColumnNames($field_name);
    $definitions = $this->entityFieldManager->getFieldStorageDefinitions($entity_type_id);
    $main_property = $definitions[$field_name]->getMainPropertyName();

    return [$table, $columns[$main_property]];
  }