Teradata support

As per overview in #304 to resolve #168 and #7.
Maybe we should have an `order by` here?