ParamQuery grid is the best open source jQuery grid plugin with enterprise features like row grouping, pivot, treegrid, column grouping, nesting, batch editing, export to multiple formats, selections, full keyboard navigation in addition to the basic features like sorting, filtering, paging, inline editing, validations, etc.
W2ui Grid Demo
W2ui Grid Methods
It's the only grid to truly support unlimited rows and columns with blazing fast performance.
Server side interaction is based on simple RESTful API and it can be implemented in any server side language i.e., Nodejs, Python, PHP, ASP.NET, J2EE, Cold fusion, etc while data can be served from and persisted in any kind of storge like Sql server, MySQL, MongoDB etc.
Free version of grid is released under GPL v3 license while Pro version is released under Commercial and OEM license. Please scroll down for feature wise comparison between free and Pro versions.