Active Query Builder VCL and ActiveX Editions 1.27 are released.
We're glad to announce the new minor version of Active Query Builder. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area.
What's new in the Active Query Builder VCL and ActiveX version 1.27?
General changes:
Support for RAD Studio 10.2 Tokyo has been made.
Polish translation has been added.
User interface changes:
Linked Objects menu behavior has been changed: a table won't be added to query if such object already presents in this subquery.
Automatic links creation has been improved: links are created only from Parent to Child table or vice vera, but not both at the same time.
SQL syntax changes:
SQLite: Right outer joins are converted to left joins by reordering objects in the FROM clause now.
PostgreSQL: Support of materialized views, TOAST tables, and foreign tables has been made.
PostgreSQL: Support for custom aggregate functions has been added.
Oracle: Calculation of SQL expression data types is made.
ODBC literals and function calls syntax is supported now in all SQL syntaxes.
API improvements:
Query Transformer is now capable of renaming output query columns.
The new TacQueryTransformer.RenameDuplicatedColumns (ActiveX: IQueryBuilder.QueryTransformer.RenameDuplicatedColumns) property prescribes to explicitly specify all the columns in the query SELECT list by expanding the asterisk items, then find and rename the unnamed and duplicated column names.
Autosizing of new objects being added to the Design Pane has been made. The new TacQueryBuilder.DatasourceOptions.TableWidthMode (ActiveX: IQueryBuilder.TableWidthMode) property can be set to the following values:
- twmAutosizeByContent: width is calculated to fit the whole text content,
- twmAutosizeByFieldName: width is calculated to fit the longest field name.
The new TacQueryBuilder.PartialMetadataLoading (ActiveX: IQueryBuilder.PartialMetadataLoading) property being set to True lets load metadata only for objects that were used in the query on assigning it to the SQL property.
The new property TSQLBuilderConditionFormat.NewLineBefore (ActiveX: ISQLBuilderSelectFormat.WhereNewLineBefore, ISQLBuilderSelectFormat.HavingNewLineBefore) has been added to add line break before each condition.
We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!
We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...
In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!