How to tell if SQL is autogenerated by some tool
Trying to reverse engineering to find the tool will take too much time and you will possibly never find the solution. Debug this through an Agile methodology:
“The most efficient and effective method of conveying information to and within a development team is face-to-face conversation”
So go to your colleagues and don't be afraid to ask:
&quot;Are we using an automated tool or a drag-n-drop tool to create queries? I ask this because they really look machine-made to me&quot;
And the result can be:

Yes, they are written by a tool: and show to your colleagues how painful this choice can be for your performances
No, they are written by Tom: and talk to Tom and say &quot;Hey, Tom, I was having an hard time reading through your code, is there any way I can help you...&quot;

Be nice to people. Machines cannot change but humans can.