Expore the possibility to use SQLite as a backend instead of the Posgresql

### Proposed feature

SQLite can be used as an alternative storage in the Cloud Agent.

### Feature description

Using SQLite library as a storage can:
1. replace the Postgres DB and simplify the usage of the Cloud-Agent in the dev mode for QA or use cases
2. speedup the integration test (when `in-memory` SQLite is configured)

### Anything else?

_No response_