I basically want to use a headless CMS to kickstart a project but not be locked in and eventually build a custom backend
We're an open-source CMS where you completely own your database. Right now we're MongoDB-only, but we are actively working on adding Postgres support and that should be done VERY soon.