[Rosetta] Refactor indexer SQL queries

[joaosreis]

This pull request refactors SQL queries to improve the efficiency and readability of the indexer queries and provide logging for debugging purposes.

This was tested using the Rosetta indexer test against current mainnet archive database.