Active Query Builder News

March 04, 2013

Active Query Builder Java Edition 1.6 is released.

We're glad to announce the new version of Active Query Builder Java Edition. You can download the latest free trial at the download page.

What's new in the Active Query Builder Java Edition version 1.6?

  • The new syntax provider for Teradata database server is made.
    Use the TeradataSyntaxProvider for the complete support of Teradata SQL syntax.
  • PostgreSQL: Support for analytic expressions is made.
  • Oracle: Optimizer hints are supported now.
  • Performance optimizations are made.
  • Sub-query tab captions display sub-query alias instead of query text now.
  • The LinkChanging and LinkChanged events are added.
  • The new ComponentCreated and ComponentDestroying events notifying about query UI components created and destroying are added.
  • The new properties were added for more customizable SQL query text formatting:
    • PlainTextSqlBuilder.get/setDynamicIndents(): allows to indent the next item in the list to the same position as the first item;
    • PlainTextSqlBuilder.get/setDynamicRightMargin(): instructs the component not to take into account leading spaces when counting line lenght to wrap;
    • SQLBuilderFromClauseFormat: get/setNewLineBeforeComma(), get/setNewLineBeforeJoinExpression();
    • SQLBuilderItemListFormat (formats SELECT list, GROUP BY and ORDER BY items): get/setNewLineBeforeComma().
» All Active Query Builder news

Tweets

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.

Screenshots

Join Types

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

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

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.

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


Active Query Builder Screenshots

Social networks

Active Query Builderon Google+