I'm not a huge fan on SQL because the more relations you have the more complex your JOINs become. It becomes a nightmare. I don't want to go down that path.
I've used mongodb before I switched to surrealdb, and it was pretty good for simple stuff, but for more complex queries it also becomes difficult. Also scaling it requires knowledge I currently don't have nor do I care to learn.
I'm looking at edgedb, cockroachdb and possible just got old fashioned mysql again if I have to do sql all over.
Are there any new dbs that have re-invented SQL at all besides surrealdb?
The main motivation for building StatelyDB was exactly what you describe in your first paragraph - the difficulty of migrating data and changing your mind once you've already got data in the database. We're building an elastic schema that you can easily migrate, with automatic backwards compatibility so you don't have to update your applications all at once. Take a look, we'd love feedback.
No technology can reduce the inherent complexity of your problem space. If you are serious about whatever it is you are building, consider that using bespoke or atypical database solutions may reduce your chances of success by several orders of magnitude.