For what use case? If it is for a CMS / Web based thing that modifies the structure of the database or inserts some seed data - Use Migrations If it is for so

For what use case? If it is for a CMS / Web based thing that modifies the structure of the database or inserts some seed data - Use Migrations If it is for some ETL type job where you are using SQL then migrating to a tool like DBT is probably wise.