Reduce some of the SQL line lengths
Add .gitignore
Add TODO file
Test updates

Uncertain of where I was going with these, but more tests fail without
the changes so I'll leave them in and refactor shortly.