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 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.
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 dialects.
- Easy visual 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).
- Defining user-friendly aliases for tables and field names.
- Powerful means of SQL query analysis and programming modification.
- Working in offline mode, storing metadata in XML files.
- Restricting access to unwanted objects, preventing query execution.
- Sophisticated SQL parser, support of most popular database servers.
- SQL query text formatting.
- Ability to localize the component