Summary

An approach to addressing #1668, TBD if tradeoffs/peculiarities are worth it.

• Custom handle asset_id=0 and application_id=0 queries to detect creation transactions that would be filtered out based on underlying data storage. This implementation would result in corresponding creation transactions for a given app/asset being returned when filtering for app/asset id = 0 or app/asset id = actual id.

When complete, should close #1668

Test Plan

For asset_id/app_id zero cases, new e2e handler and a postgres query builder tests were added to explicitly exercise these scenarios.