[rjf1990]

I'm also not a professional programmer, but I used to do a lot of data analytics for a large company which required lots of SQL.

I often used excel to track my code and keep it organized. Part of this is that most of my work was done in excel; the SQL queries were just to get the data workable. But, so many things would change and it was easy to use the concatenate features of excel to change variable names, table names, and stuff like that.

[logn]

I am a professional programmer (although not a DBA), and have used excel to generate SQL scripts. You can often just put all the variable in cells and then use string concatenate to add in the parts of a SQL script that repeat. It works well and lets others easily maintain/modify it. These are mostly for throwaway scripts or one-off analysis tasks.