What's new in the Active Query Builder VCL and ActiveX version 1.27?
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.
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.