Make some changes to the library itself - edit the Adapter interface to be more compatible and with basic default methods .
Also created the OptimizedDataAdapter which is responsibly for Limit and Offset commands/queries, make an example of this ( test5(); ) and worked very well, we have some issues with some milleseconds(6-7) of losing performance  there but I will fix it