Tests have been written for select, from, join, where, and orderby.