A working version of the API, some SQL filter changes

Here's an ugly working version of the API. Let's update the development server and have our product owner test.