Derby 10.5.1.1 introduced support for limit and offset. This is used in within Torque, so limit and offset does not work for Derby < 10.5.1.1