To answer the rest of the question, if you want a 'new' route, use the Create function and then use MapFunc to map it accordingly. Put your raw SQL into the Create block or use an orm like beedb to make database interaction a little easier.
I hope I didn't muddy the waters. I'm sure someone else can answer this better than I can.