Active Query Builder Web API

Online SQL Builder Demo

Online SQL Query Builder - HTML Demo

This page demonstrates a full-featured data browsing user interface with Online SQL Query Builder created using the Active Query Builder Web API.

Such Online SQL Query Builder can be added to a web project of any programming environment and architecture, including Java, NodeJS, JavaScript, PHP, Python, Ruby, Perl, etc.

All user-requested data manipulations, such as sorting, filtering, pagination and calculation of totals are performed on the server side by database server. Meanwhile, SQL text is not passed to/from the client ensuring 100% protection from SQL injection attacks.

Custom JqGrid JqxGrid

Click the column headers to change sorting by a column. Hold the Ctrl key on clicking to sort by several columns.

Server-side totals calculation is possible only when sorting is defined.

Source code