Implement support for database schemas integration test isolation

# Task Description

# Open Questions

# Notes

# Task List

The following tasks will need to be carried out:
* [ ] Investigate the issue.
* [ ] Provide a solution.
* [ ] Test the fix.
* [ ] Update the documentation.

# Useful Commands

# Incurred Costs

# Task Relationships

This task:
* Is a sub-task of:
* Depends on:
* Is a follow-up of:
* Relates to:

# Resources

# Useful Links

# Points of Contact

Start by investigating the integration-test setup and how database schemas are currently handled. Define what schema isolation should provide, then implement and test the support and update the documentation; the issue does not name specific files, tests, or commands.

Written by the indexing model from the issue text.