chore(engine): cleanup Persistence SPI refactoring

- remove unused DbSchemeManager
- use selectById in CaseDefinitionManager
- add note that databaseSchemeUpgrade now always returns an
  empty string
- reenable test assertions

related to #CAM-2602
chore(engine): remove redundant casts