Maybe you already do this, but it's hard to find the documentation.

We often want to run the same, fairly complicated query with different parameters, on different databases (dev/staging/prod) & compare the results.

There are a lot of ways you could support this - prompting for user input on script execution, or parameter fields above the script, or as per another suggestion, scripts that can call other scripts - so they could set initial parameters.

Or you do support something like this but it's not clear.