Move all SQL queries to `types` module

[cdknight]

To keep things more DRY, as other parts of the code might want to re-use SQL queries, we should move the majority of SQL queries to the impl of the different types.

Then, we should clean up any repeated SQL queries in the program.