feat: add database switching for redshift adapter

[MattiasMTS]

What has changed:

• [X] some refactoring of variables etc
• [X] add support for database switching
• [ ] add support for datashare switching

[kndndrj]

I take it this has been tested. Nothing seems off.

Merging