Active Query Builder  »  SQL Query Builder

SQL modification for easy data browsing

Change grouping and sorting, and apply filters and pagination to a query

• Changing the view of result SQL query data

  It's standard for any data browsing tool to have the ability to change sorting, apply additional filters and pagination to the query result data, and calculate totals. Active Query Builder enables these features without loading the entire dataset on the client.

  It provides a special API to modify the given SQL query while taking into account the structure of the query and limitations of the particular SQL syntax. Commands applied to the query can be saved and restored afterwards.

  You can learn more about the QueryTransformer API in this article: How to change sorting, add filters and limits, and apply aggregations to a query.

• Visual SQL filter builder

  Active Query Builder includes SQL Filter Builder - a handy control for applying filters to resulting query data visually in a tree-like form. The SQL Filter Builder represents the WHERE clause, close to the natural language. It retrieves a list of query output columns from the given query to enable type-safe editing of filter values.

  SQL Filter Builder connects to the QueryTransformer object and provides two-way synchronization. If you add filters programmatically, they'll appear in the visual control, so you can allow for custom ways of adding filters to improve the user experience.

  

• Query Transformer API - Quick Start Guide

• Customizable SQL query building environment
• Metadata handling and filtration
• Programmatic SQL Query analysis and modification