Updated 08272023-193436
I should start by noting that I have a gargantuan library stored in Drafts which I have subjected to all manner of experimental scripted/automated actions over the years, and - in my case, and perhaps others - I'm sure the most reasonable advice in my situation would be to simply backup my library, purge most of it, and start over.
That situation being - I have a fair amount of duplicate drafts in my library.