I find that it's usually management that ask for such things "because AI".

I mean using AI is a great way to interpret a query, determine if a helper script already exists to satisfy it, if not invoke a subagent to write a new script.

Problem with your "script" approach is how does that satisfy unknown/general queries? What if for one run you want to modify the behavior of the script?