Added Substring, Left, and Right transformations.

Also changed some SQL things and simplified the batch sizes.