Moved LIMIT/OFFSET into Dialect; more tests

* Moved generation of the limit/offset SQL clause into Dialect.
* Added more tests for the three supported SQL engines