BCF-3276: refactor migrations to use goose provider

[krehermann]

BCF-3276

Update goose and refactor migrations to use the newly added goose.Provider

This is a concrete step toward supporting multiple migrations providers.

[vyzaldysanchez]

Needs a changeset though... Will this be considered a minor change?

[cl-sonarqube-production[bot]]

Quality Gate passed

Issues
1 New issue
0 Fixed issues
0 Accepted issues

Measures
0 Security Hotspots
82.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarQube