I write all of my queries, and I read any existing queries before updating/changing them.
Each time a co-worker tries to use an LLM for a query, it gets something wrong, and I end up having to correct it.
Not sure if a more visual inspection would help.
What I have found to help, is a more hands on inspection. Forcing co-workers to actually run the queries they write, and verify the expected outcome.
Virtual tables, and test tables are cheap and easy, there is very little reason not test what you write(or even test what an LLM writes, if you are that lazy,as most seem to be.)
Each time a co-worker tries to use an LLM for a query, it gets something wrong, and I end up having to correct it. Not sure if a more visual inspection would help. What I have found to help, is a more hands on inspection. Forcing co-workers to actually run the queries they write, and verify the expected outcome. Virtual tables, and test tables are cheap and easy, there is very little reason not test what you write(or even test what an LLM writes, if you are that lazy,as most seem to be.)