For SQL since most of them are Stored procedures and they are indeed complex, the test cases would involve calling SP with a set of inputs extract the output and validate a set of fields against a specific criteria and accordingly mark the test cases as pass/fail. I wanted to know if there is a better approach than this.
I agree, anything that can be done in batch can be done in python, but it was more of a trade-off. For simpler requirements batch script can be done in few lines of code whereas for the same in python it will actually take lot more to write taking into account logging, error handling etc.
I had asked another question on RPA in separate thread Automating Desktop application using python Robotframework - #2 by Wolfe1. Would you know anything about it?
Thanks for your input so far.