Active Query Builder is a Java tool allowing users to create SQL queries visually and programmatically. It simplifies complex SQL tasks and provides robust functionalities for an efficient SQL query experience.
Active Query Builder Java Edition is a powerful, visual component built specifically for Java environment. It allows users to build complex SQL queries quickly and easily through a user-friendly graphical interface. This software renders all SQL features, including sub-queries and unions, making them easily accessible to both beginners and experienced query writers alike.
Active Query Builder's interface is reminiscent of MS Access and SQL Server's visual query building interface, resulting in it being familiar to most database users. The software eliminates errors that could arise when writing SQL queries, ensuring near-instantaneous results. By embedding Active Query Builder into Java applets and applications, beginners are given easy access while professionals have at their disposal a powerful tool to speed up query writing.
Control over the SQL query lies with the user, and Active Query Builder gives users an internal query builder object tree. This tree represents all parts of the SQL query, making navigation easy. User-friendly aliases hide database object and field names, making it possible to combine visual query building with direct SQL query text editing.
Active Query Builder is an unfailing assistant in parsing, analyzing, and programming creation and modification of SQL queries. It provides maximum flexibility to end users without the software losing control over the operations it performs. The software supports Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, DB2, Firebird, and other dialects.
Two editions of Active Query Builder are available: the Standard Edition and the Free Edition. The Free Edition has some API limitations and supports only the ANSI-92 SQL dialect. Overall, Active Query Builder is an excellent software that provides convenience and efficiency in SQL query building.
Active Query Builder's interface is reminiscent of MS Access and SQL Server's visual query building interface, resulting in it being familiar to most database users. The software eliminates errors that could arise when writing SQL queries, ensuring near-instantaneous results. By embedding Active Query Builder into Java applets and applications, beginners are given easy access while professionals have at their disposal a powerful tool to speed up query writing.
Control over the SQL query lies with the user, and Active Query Builder gives users an internal query builder object tree. This tree represents all parts of the SQL query, making navigation easy. User-friendly aliases hide database object and field names, making it possible to combine visual query building with direct SQL query text editing.
Active Query Builder is an unfailing assistant in parsing, analyzing, and programming creation and modification of SQL queries. It provides maximum flexibility to end users without the software losing control over the operations it performs. The software supports Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, DB2, Firebird, and other dialects.
Two editions of Active Query Builder are available: the Standard Edition and the Free Edition. The Free Edition has some API limitations and supports only the ANSI-92 SQL dialect. Overall, Active Query Builder is an excellent software that provides convenience and efficiency in SQL query building.
What's New
Version 1.0.5: Version 1.0.5 introduces numerous demo projects to illustrate different aspects of the component's functionality: working with non-GUI tasks (programmatic SQL query creation, SQL parsing and modification), metadata filling, alternate names and events usage.