LCFS - Squash Latest Migrations

[AlexZorkin]

Description:
Squash existing migrations using SQLAlchemy and Alembic, ensuring all materialized views are preserved. Review and pull the latest versions of each materialized view, then consolidate migrations into two—one for models and one for materialized views.

Purpose:
To simplify the migration process by reducing the number of migrations ensuring materialized views are retained and correctly handled, as an automated squash will not account for these views.

Acceptance Criteria:

• Review all migrations to identify the latest versions of each materialized view.
• Combine and squash all standard models into one migration.
• Move all materialized views into a second migration.
• Ensure no data or schema integrity is lost during the squash.

Additional context:

• SQLAlchemy and Alembic are used for migrations.
• The materialized views require special attention as they won't be automatically squashed.
• This squash is part of a larger effort to streamline the migration history and improve manageability.