Active Query Builder
makes complex database queries EASY!

  • What is Active Query Builder?


    Active Query Builder is a visual SQL query builder component that allows your end-users to build complex SQL queries via an intuitive visual query building interface easily. Active Query Builder is also an excellent SQL parser to analyze and modify SQL queries programmatically.


    Active Query Builder is available in the following editions:
    Active Query Builder .NET Edition
       » WinForms .NET component
    Download free trial now
    Active Query Builder Java Edition
       » Swing-based Java bean component
    Download free trial now
    Active Query Builder ActiveX Edition
       » ASP.NET-ready COM/ActiveX control
    Download free trial now
    Active Query Builder VCL Edition
       » Delphi and C++ Builder component
    Download free trial now


    Whether it's embedded into a database administration tool or a user report generator, in a Windows application or web page, Active SQL Query Builder component is your best solution for almost any software. Its user-friendly interface and unique query parsing and research capabilities provide optimized results and is sure to increase the number of potential users of your product.

  • Active Query Builder for end-users:


    Active Query Builder component suite is a perfect choice for both SQL beginners and experienced query writers. It renders all SQL features, such as sub-queries and unions, very easy to accomplish and provides the professional user with everything he or she needs to efficiently work with SQL queries. The interface of Active Query Builder is similar to MS Access and SQL Server’s visual query building interface, so it is already familiar to most database users. It can hide unintelligible database object and field names with user-friendly aliases without loosing the ability to combine visual query building with direct SQL query text editing.
    Active Query Builder practically eliminates mistakes when writing SQL queries while achieving almost instant results.

  • Active Query Builder for developers:


    Developers will be happy to know that we made Active Query Builder’s user interface very easy for people to use, yet the software is extremely powerful and accessible to programmers. Active Query Builder can be used as an unfailing assistant in parsing SQL queries. Active Query Builder provides maximum flexibility to your end users without your software losing control over the operations it performs: the fields and tables the user selects in a query, the parameters he used in a query and the data he gets in result dataset.
    User queries are no longer a black box; they are an open book!

  • Active Query Builder for project managers:


    Software project managers constantly strive to increase the range of potential users of their product, improve its usability and speed up the software development process. If the feature list of your product includes SQL query writing then Active Query Builder can help you with each of these goals. By embedding Active Query Builder into your product, you can make it easy for beginners and provide a powerful tool for professionals.


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.
CodeGear - Where Developers Matter

Screenshots

Multiple joins

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

Join Types

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

Criteria pane

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

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.


More Screenshots