Update lazy database creation pattern for more specific exceptions etc.

Problem/Motivation

In 📌 Implement lazy database creation for sessions Active I initially copy-pasted the lazy table creation pattern from the database cache backend, and @phenaproxima found numerous things that can be updated. Most notably SchemaObjectExistsException and SchemaObjectDoesNotExistException are available now.

Steps to reproduce

Proposed resolution

Try to bring all the places that implement the lazy creation pattern up-to-date with the new exceptions, and any other improvements from the session implementation.

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet