Provide a drush wrapper to destroy/delete migration tables

Rerolled for 6.0.x as well as Drush 12.

Still needs to implement tests.

This looks really great!!! Thanks for picking this up.

1. +++ b/src/Drush/MigrateToolsCommands.php
   @@ -606,6 +606,74 @@ class MigrateToolsCommands extends DrushCommands {
   +   * @param string $migration_names
   ...
   +  #[CLI\Argument(name: 'migration_names', description: 'Restrict to a comma-separated list of migrations (Optional).')]
   

   For consistency, we call this $migration_id in other places.

2. +++ b/src/Drush/MigrateToolsCommands.php
   @@ -606,6 +606,74 @@ class MigrateToolsCommands extends DrushCommands {
   +  public function destroy($migration_names = '', array $options = [
   

   Could we add a test case for this command?

reroll patch

This is pretty close. Can we fix the phpcs, etc issues and add a test case? That's all that is missing from landing this.

This will be a great feature. I wonder if delete migration tables should be included in the description, to make it clearer what the command actually does ... it could something like this?

Now
+ * Destroy persistent status for one or more migrations.

Better?
+ * Destroy persistent status for one or more migrations, deleting migration tables.

I have fixed the phpcs and phpstan issues.

Tests still need to be added.

@heddn do you want me add full tests similar to the below MR or do you have any suggestions ?

https://git.drupalcode.org/project/drupal/-/commit/d4abe119f885d41104b98...