hiddentao/squel — pull request #74 by tutorazadi (2014-06-26 18:27:34+00:00)
Title: Added T-SQL functions for TOP and OFFSET/FETCH

Tests have not been made, namely due to the fact that I am unaware of how to make Mocha tests. I already wrote hiddentao about this beforehand. Additionally, the changes are not in the minified version of the file, as I am not aware of the proper process for adding to this, but as soon as I know, I will make sure to do this in future contributions.

There are two functions added to the end of the squel.js file, and they are as follows:
.top()
Example: SELECT TOP 5 * FROM tableName

.offsetMS(offset, fetch) # fetch is an optional argument
Example: SELECT * FROM tableName OFFSET x ROWS
Example: SELECT * FROM tableName OFFSET x ROWS FETCH NEXT y ROWS ONLY