I've been writing SQL code for years now and the QA loop is always done by a human, in every job I've had.

Any time I propose automated testing or some forms, people dismiss it because every data set is different blah blah blah.

What I want to do is build something that scans a SQL script and writes to a text file everything the QA person should check based on the SQL script.

I know i could do it using powershell, but that's hardly high tech. I looked into building a VS Code extension to do it, but I would be learning that all from scratch.

Does this sort of thing already exist before I go and re-invent the wheel? Where It can parse text and based on pre-determined rules output something specific?

Many thanks in advance.