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.


    Today Active Query Builder is availiable in the following editions:

    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 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 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. Active Query Builder practically eliminates mistakes when writing SQL queries while achieving almost instant results.
    With Active Query Builder, SQL query “writing” is no longer a chore.

  • 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 user queries. Active Query Builder provides maximum flexibility to your users without your software losing control over the operations it performs: the fields and tables the user selects in a query and the data that gets displayed on the screen. No more parameter problems; Active Query Builder lets you find out not only each parameter’s name but also the names of each table and field that each parameter applies to.
    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.
    Active Query Builder is a profitable investment: by purchasing Active Query Builder now, you will receive all updates, including major upgrades (2.0, 3.0, etc.) free.

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

Multiple joins
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Subqueries

Subqueries
Subqueries are located on separate tabs and can be accessed and built visually as easy as the main query.

Unions

Unions
Unions are managed from within the union panel at the corner of the visual query builder pane. You can build a query containing several unions in a few clicks!


More Screenshots