Hacker News Reader

Not sure what language you are talking about. For Java there is an awesome https://www.jooq.org/doc/3.19/manual-single-page/

Having said that: I stopped using it as writing plain SQL seems much more effective.

If you are fine with search and replace to refactor your code then ok.

Or you could use an IDE that supports refactoring SQL, like Intellij IDEA.