> I’ve skimmed over the code and it was processing hardcoded index positions. I repeat the person who did that had no concept of a loop. Since the query was returning more than 250 results the remaining rows were being ignored.

Unrelated, but this reminds me of a time when I had to write some code in some proprietery programming language in some industrial automation project to program a PLC. The language was similar to Visual Basic but lacked support for basic things such as for loops. I spent some time creating a "meta-language" that would compile code down to this language with added support for loops and some other stuff. Then I would paste the compiled code in the proprietary software each time I had to change anything.