Active Query Builder Java Edition is a visual component for Java environment to allow your end users to build complex SQL queries visually via user-friendly graphical interface easily. Active Query Builder 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. It is a perfect choice for both SQL beginners and experienced query writers.


The interface of Active Query Builder is similar to MS Access and SQL Servers 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. By embedding Active Query Builder into your Java applets and applications, you can make it easy for beginners and provide a powerful tool for professionals.


Active Query Builder gives you full control over the SQL query: you can easily navigate it using the internal query builder objects tree that represents all parts of the SQL query. 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 can be used as an unfailing assistant in parsing, analyzing and programming creation and modification of 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.


Active Query Builder Java Edition supports Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, DB2, Firebird, and other SQL dialects. There are two editions available: the Standard Edition and the Free Edition. The Free Edition has some API limitations and supports only the ANSI-92 SQL dialect.