SQLAlchemy provides a number of ways to fetch results from the database. While developing new endpoints, I am slowly learning how to use the various methods better. This is refactor refactors some old implementations to make them more consistent with my latest understanding of how to use SQLAlchemy core. It's likely this still isn't ideal, but it's better and the returned results will also be more similar to ORM objects which would be used in the future (e.g., attribute access instead of key access).
SQLAlchemy provides a number of ways to fetch results from the database. While developing new endpoints, I am slowly learning how to use the various methods better. This is refactor refactors some old implementations to make them more consistent with my latest understanding of how to use SQLAlchemy core. It's likely this still isn't ideal, but it's better and the returned results will also be more similar to ORM objects which would be used in the future (e.g., attribute access instead of key access).
Closes #106