I do go file by file, but I just copy and paste the same query into each. It also gives me a chance to do a quick review before moving on. It’s still a manual process but it’s a HELL of a lot faster than manually refactoring.
(I can’t give too many more details though since I use proprietary software that isn’t public facing)