> One aid I do lean on heavily though is a REPL. Load the code and do some interactive work with it. Inspect the data, test some transformations, and then write code to do what works. That's my current approach to situations that I cannot immediately and accurately write in one pass.

Honestly, this sounds mostly like what you're chastising, except you're doing it outside of the main workflow.