Pathauto bulk update for taxonomy terms with unchecked “Generate automatic URL alias” I have the same issue addressed for D7 here:
Bulk Generating URL aliases for taxonomy terms doesn&#39;t do anything
or here:
Bulk update for unchecked &quot;Generate automatic URL alias&quot;

And I'm looking for a corresponding workaround for D8, querying the DB directly.

For D7 seems that the following solution works:

UPDATE pathauto_state SET pathauto="1" WHERE entity_type="taxonomy_term";


I did some research for D8:


cannot find any "pathauto_state" table within a D8 database
so I tried to find how and where the “Generate automatic URL alias”
is stored but
    without success (see also for this:
    Where is the &quot;Generate automatic URL alias&quot; setting stored?)


Thank you
As I know there is no simple SQL query to update &quot;Generate automatic URL alias&quot; status for nodes and terms for Drupal 8.
Data contained in table key_value but I don't think it's possible to use it directly.