Entity reference field query is not working when using DER field as a base field.

Problem/Motivation

As Dynamic Entity Reference now supports entity field query → mentioned, DER field can be queried using entity:entity_type specifier.

I tried create DER field through bundle field config, it works pefect.
But if I create DER field through base field defination, it throw 'field_name' is not found error,
unless I set setCardinality(FieldStorageDefinitionInterface::CARDINALITY_UNLIMITED).

Steps to reproduce

1. Create base field to any entity type.

    $fields['my_der'] = BaseFieldDefinition::create('dynamic_entity_reference')
      ->setLabel(t('My der'))
      ->setDisplayOptions('view', [
        'type' => 'dynamic_entity_reference_label',
      ]);

2. Query entities using condition to the der field created above.

$storage = \Drupal::entityTypeManager()->getStorage('the_entity_type_id');
$query = $storage->getQuery();
$query->accessCheck(FALSE)
  ->condition('my_der.entity:some_entity_type_id.label', 'Some thing');
$rs = $query->execute();

Proposed resolution

I seems that entity reference query is only working when the fheld is stored as a seperated table.

Remaining tasks

User interface changes

API changes

Data model changes