I am working on a jqgrid module. There is a chance it can work for what you are trying to do. The module is designed around web2py tables but the JqGrid class can be subclassed and the data method, the method used to access the data for the jqgrid rows can be overridden with whatever you like. As long as it returns data in the expected format, it should work.
The application is here: http://www.web2pyslices.com/slices/take_slice/140 Let me know if you need help with that.
