I'll be honest, CockroachDB looks fishy.

    https://www.cockroachlabs.com/docs/stable/learn-cockroachdb-sql.html

CockroachDB SQL? Isn't it supposed to be 100% PostgreSQL compatible?

    https://www.cockroachlabs.com/pricing/
    CockroachDB Core - Open-source with foundational features.

Uff... Let's go give a look at the licenses: https://github.com/cockroachdb/cockroach/blob/master/LICENSE

So many licenses, including the Business Source License which is non-free license.

Also there's this CockroachDB Community License (CCL), which I guess is a made-up license that's going to include some whatever terms.

I might still accept this mix of licenses however I can't find the definition of "foundational features" -- what do I "lose" by using the OSS version instead of one of their managed offerings?

From a quick overview, it's soft-no from me (in the sense that it probably wouldn't be my first choice).