refacor(persistence): extract PersistenceSession SPI

- extract PersistenceSession SPI for handling persistence operations
- DbEntityManager delegates to PersistenceSession for executing
  operations
- DbSqlSession is default Persistence SPI
- move SELECT operations to DbEntityManager
- refactor Schema Management

related to CAM-2602