Remove queries from API route and convert to query! macros

[FlynnOConnell]

Separate db queries into their own module as functions that can be called from the API route