Move methods that return SQL into the SQLDialectTrait.

The dialects should be responsible for all SQL snippets. This should
help consolidate platform differences into once place.