[SPIKE] Explore other migration strategies for analytics db schema

[widal001]

Summary

The current analytics codebase has adopted a simple approach to managing version-controlled schema changes, however this custom approach lacks some key features that are common in more robust migration tools like alembic.

We should evaluate common migration strategies/frameworks and decide whether or not to adopt them in our project.

Acceptance criteria

• We've evaluated other migration tools and noted our thoughts in this ticket
• An ADR has been drafted to document our decision (can be done as a separate ticket to close this out)
• Additional tickets have been created to either switch to a new migration framework or to implement similar features