When using scripts which assume database is set at connection level, an explicit DATABASE databaseName; is required to prepended.
It isn't always feasible/ideal to amend files with this, as you may want to run the same file/scripts with the connection defining where you want to do it.
Describe the solution you'd like
The ability to provide the database to be used on connection
Describe alternatives you've considered
Manually running which works, however, doesn't quite fit with the need to run across multiple different connections
When using scripts which assume database is set at connection level, an explicit
DATABASE databaseName;is required to prepended.It isn't always feasible/ideal to amend files with this, as you may want to run the same file/scripts with the connection defining where you want to do it.
Describe the solution you'd like
The ability to provide the database to be used on connection
Describe alternatives you've considered
Manually running which works, however, doesn't quite fit with the need to run across multiple different connections