The main use case, in my opinion, is for tests/CI. SQLite has traditionally been used to quickly run tests, however, if your actual infra uses PostgreSQL then the value is limited.
You think the main use for sqlite is running tests?
You think the main use for sqlite is running tests?