Add a LIMIT clause to the given SQL SELECT. Expects any database-specific offset and limit adjustments to have already been performed (ex. UseMaxForLimit, OffsetStartsAtOne).

Generates a string to limit the result set to a number of maximum results with a specified offset into the results. Expects any database-specific offset and limit adjustments to have already been performed (ex. UseMaxForLimit, OffsetStartsAtOne). Performs error checking based on the various dialect limit support options. If both parameters and fixed valeus are specified, this will use the parameter option if possible. Otherwise, it will fall back to a fixed string.