[FEATURE] Add support for in-process database

[badmonster0]

What is the use case?
Currently we only support Postgres. A in-process database can be helpful for many scenarios in which users don't want to start a server process.

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.