I opened a gedcom from MyHeritage.com (+5000 people all imported from shared trees, no consistency and lot of mistakes).
I have spend quite some time on those forums to find what were the best practices, used in-build tools to clean duplicates, letters capitalisation, etc. but it quickly becomes necessary to download an SQL software such as SQLiteSpy to run queries on the entire database.
I found a few ones on SQLite tools for Rootsmagic (https://sqlite4roots...space/home.html), great to add weddings fact to all couples and had to spend like an hour per query to modify them. I wanted for example an alt Name (married) "Mrs. wife.firstname husband.lastname", a death fact to all person not living (who had no death fact), add a * to all suffix to identify they were imported from MyHeritage (unreliable), put about (abt) in front of all dates, remove all 'Y' in details, etc.
I have poor knowledge of SQL (only through Microsoft Access but advanced in VBA), so this is only through testing simple modifications that I can achieve what I want to so far. I am pretty sure a few people have already written those or some other people would be interested in mine. There seemed to be a wiki but links are broken.
I would love to have a querry group, like RootsMagic Wish List (or stack overflow), where we could share our queries and ask-answer rootsmagic-sql specific questions