Active Query Builder

Visual SQL Query Builder for .NET

Active Query Builder for NET is available for WinForms and ASP.NET environments. Versions for WPF and Silverlight environments will be available soon.

Army swiss-knife for data-aware applications

Active Query Builder is not just a component to build SQL queries visually. It's is a full-featured set of tools to manage metadata, work with SQL queries, and assist in retrieval of data from the database.

Active Query Builder lets create full-featured applications quickly to retrieve data from almost any database. It provides highly customizable and convenient interface for end-users to understand database schema and to work with queries in the most efficient way.

  • Simple and clear visual SQL query building interface
    • Easy building of complex SQL queries with unions and sub-queries.
    • MS-Access style user-friendly interface with drag & drop support.
    • Two-way SQL query building (combined with SQL text editing).
    • Customizable SQL query text formatting.

  • Customizable query building environment
    • Complete substitution of unintelligible object and field names for user-friendly aliases.
    • Representing high-usage expressions and sub-queries as ordinary database objects and fields.
    • Rearranging database objects by subject areas or by any other characteristics.

  • Easy metadata management
    • Manual hiding of unwanted objects, automatic filtration by schema or object name.
    • Loading metadata programmaticaly from different sources (via web services or from datasets).
    • Working disconnected from the database, storing metadata in XML files.

  • Powerful API to analyze and modify SQL queries
    • Restricting access to unwanted objects, preventing SQL query execution.
    • Quick access to comprehansive information about the query: database objects and fields, query columns and parameters.
    • Easy changing of SQL queries to transfigure result data according to the end-user requests.
    • Full access to internal query representation obejcts for SQL query analysis and modification.

News

Testimonial

With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.

Thanks to all the team involved. Please keep up the good work.

Screenshots

Join Types

Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.

Unions and Sub-queries

Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.

Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.


Active Query Builder Screenshots

Social networks

Active Query Builderon Google+