Dialect don't support native usage of limit().offset() methods due to type collision: sqlalchemy by default provide all integer bound variables as Int64, when YQL requires UInt variable to be passed to LIMIT OFFSET.
In this PR
In this PR I add the optional type casting to the LIMIT OFFSET clause to allow native usage of SQLalchemy methods related to.
Problem
Dialect don't support native usage of
limit().offset()
methods due to type collision: sqlalchemy by default provide all integer bound variables as Int64, when YQL requires UInt variable to be passed to LIMIT OFFSET.In this PR
In this PR I add the optional type casting to the LIMIT OFFSET clause to allow native usage of SQLalchemy methods related to.
Bonus
Dialect was enriched with all integer YDB types.