Refactor API for it to be runnable with an empty db

Currently we have an issue that console isn't runnable without historical data from the indexer db which api also depends on. It causes quite some issues:

• this is obviously a tech debt which impacts decisions like CDCI workflows
• we can't run integration/functional/e2e tests in CDCI as imported dbs are too large
• it's only a matter of time when we or potential contributors aren't able to import a db as it grows constantly

What we need to do:
Refactor api to be runnable with empty data

• base
• Implement historical data seeders

Bonus points:

• migrate db schemas from sequelize to drizzle
• generage missing migrations

Start by tracing how the API and console depend on historical data from the indexer database, then identify the assumptions that prevent an empty database from working. Review the historical data seeder requirements and the database schemas managed by Sequelize. Done means the API can run with empty data and the required historical data can be seeded; CDCI integration, functional, and end-to-end tests should no longer require large imported databases.