Relationship query 'where' statements

I still insist to use my logic of the query. See the parent issue for details.

Also, I faced another error
Column not found: 1054 Unknown column 'node_field_data.bundle' in 'where clause': SELECT

The code

    // Filter by entity bundles selected while configuring the relationship.
    if (!empty(array_filter($this->options['bundles']))) {
      $this->query->addWhere('recently_read', "$basetable.bundle", array_filter(array_values($this->options['bundles'])), "IN");
    }

was replaced by

    // Filter by entity bundles selected while configuring the relationship.
    if (!empty(array_filter($this->options['bundles']))) {
      $entity_type = $this->entityTypeManager->getDefinition($this->definition['entity_type']);
      $bundle_key = $entity_type->getKey('bundle');
      $this->query->addWhere('recently_read', "{$basetable}.{$bundle_key}", array_filter(array_values($this->options['bundles'])), 'IN');
    }