[Project] Optimize database queries

We can trace many reliability and performance issues to sub-optimal database queries. Here, we attempt to tackle some of the most impactful database queries in the app.

## Plan
The general approach is to reduce the complexity of the database queries we are performing. At the same time, we can defer performing some of the queries until the user interacts with the UI that requires that data.

Also, by using TanStack Query for the database queries we can regain caching of the queries. This will also provide good options for automatic and manual retries.

## Related Issues

### Tasks
- #357
- #304
- #369
- #370
- #371
- #372

### Addresses
- #263
- #324
- #240
- #225
- #301
- #269
- #401

### Consider
These issues may be partially or completely solved by the effort in this issue.

- #314
- #184
- #410