Moving from a DB engine to another, even if technically possible (right abstractions and everything), is often extremely painful once you have a few years of data.
(I'm currently involved in migrating quite a few large DBs, and it's a pain for everyone: SREs, support teams and the customers).
But yes, there is no "one size fits all", it depends pretty much on how your org is operating.