[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.