As a developer, I want to be able to pass "dynamic" values to the UI while queries are running, to inform the user of activity. For example, when I have a default that requires, say, a template/script having 5 queries to run before it fills an input field, I want to indicate a percentage of "20%/40%/60%/80%/100% done" before the input field(s) get filled. Or, I want the field(s) that will be filled by the result of the SQL script to indicate activity (an hour glass, or 1-dot-2-dots-3-dots-1-dot-2-dots-3-dots, you get the idea, something like a spinner) in the input field as long as the default template/script gets executed, for long(er)-running scripts. The UI remains responsive and active during execution of the SQL script(s), so the user experience would improve because of this.
This idea is based on the case presented here:
https://community.thinkwisesoftware.com/questions-conversations-78/progress-or-activity-indicator-for-automatically-filled-fields-3631