This approach (declarative schema management) is definitely gaining in popularity. I'm the author of https://www.skeema.io https://www.skeema.io which provides

This approach (declarative schema management) is definitely gaining in popularity. I'm the author of https://www.skeema.io https://www.skeema.io which provides declarative schema changes for MySQL and MariaDB -- it's now used by a few hundred companies and is downloaded/installed 30k times per month, due in part to heavy usage in CI/CD pipelines. There are a few other tools in this space, such as Migra and sqldef.