[WIP] Support for unified hosts

[jh-db]

What changes are proposed in this pull request?

For reference only.

How is this tested?

Not really tested yet

[github-actions[bot]]

If integration tests don't run automatically, an authorized user can run them manually by following the instructions below:

Trigger: go/deco-tests-run/sdk-py

Inputs:

• PR number: 1099
• Commit SHA: 461624f5fa76b98ad0469e28aef181f2b823a6dc

Checks will be approved automatically on success.

[github-actions[bot]]

Please ensure that the NEXT_CHANGELOG.md file is updated with any relevant changes. If this is not necessary for your PR, please include the following in your PR description: NO_CHANGELOG=true and rerun the job.