I had the following idea recently: Go through all scripts/programs that send queries to the db and append a comment to the queey containing a unique id for that

I had the following idea recently: Go through all scripts/programs that send queries to the db and append a comment to the queey containing a unique id for that query that links it to the script/program. The query log hopefully shows the comment with the id so you can trace the origin.