Refactor API for it to be runnable with an empty db

[ygrishajev]

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