I am interested in your use case where you have a situation with multiple databases, possible with different schemas, where you want to run the same sql on all of them. Maybe some kind of data lake? I have not come across this. But admittedly I have not worked in enterprise (I take to mean thousands of employees)
In enterprise environments this is pretty common. I've worked at places with over 100 developers and 30 testers. So you have a situation with hundreds if not thousands of databases and then multiple schemas in each database. So imagine trying to manually validate if your script will work on all those databases and against all those schemas. How difficult of a task that is.