Not Compatible with Superset Server Pagination Feature

[cardilloscreations]

I believe the root cause is because they use OFFSET, but when I tried to enable this feature to allow more efficient database browsing through Superset, I cannot change pages and get an error about the OFFSET instead. This is like what was reported in issue #25 but that is broader (and includes reference to this problem from a pure SQLAlchemy point of view).

I'm opening this separate issue because it may be easier to solve in Superset specifically by providing the right dialect for the pagination using the special LIMIT keyword instead of OFFSET. If not, then perhaps that's feedback Superset needs to hear. If that ends up being the case, then resolving #25 should resolve this as well, because they're probably trying to use SQLAlchemy's offset as well.

Example of the error when trying to use Drill Into and then navigating to another page of the results:

Error: unexpected token [OFFSET]
LINE 10: OFFSET 50
         ^

[nwoolmer]

Hey @cardilloscreations , please can you test this and then close if resolved.

We may add OFFSET to the SQL syntax for general compatibility in future.

[cardilloscreations]

Just upgraded to 1.1.4 and confirmed that it's working properly now. Thanks! :D