Active Query Builder 3 Core Edition v.3.13.0.2262
+ MS SQL Server, Oracle: Support for CROSS APPLY, OUTER APPLY joins is added. + Oracle, MySQL, PostgreSQL, Snowflake DB: Support for NATURAL joins is added. + The new QueryRoot.LoadConditionsToSeparateRows property id added to load conditions from WHERE and HAVING into separate rows. - Minor bug fixes are made.
Active Query Builder 3 Core Edition v.3.12.4.2261
= Minor parsing improvements are made.
Active Query Builder 3 Core Edition v.3.12.3.2260
= Sybase and SnowFlake DB: Parser ambiguities are eliminated.
Active Query Builder 3 Core Edition v.3.12.2.2258
= MSSQL Syntax Provider: New properties to control generation of prefixes for fields are published. Change carefully as this may lead to incorrect field qualification for objects from linked servers: UseObjectNamesAsDefaultAliases, UseObjectNamesAsDefaultAliasesForObjectsFromOtherServer. - Snowflake DB: The parser ambiguity for objectColumn is eliminated.
Active Query Builder 3 Core Edition v.3.12.1.2257
+ Oracle: Support for Lateral, Pivot, Unpivot is added. + Snowflake: Support for Lateral, Flatten and Position clauses is added. = MS SQL Server: Support for aliases after join hints like "(NOLOCK) Alias" is added.
Active Query Builder 3 Core Edition v.3.12.0.2256
= Demo projects are migrated to net6-windows. = Obsolete API usages after migration to net6-windows are eliminated.
Active Query Builder 3 Core Edition v.3.11.6.2255
+ PostgreSQL: Support for [NOT] MATERIALIZED CTE hints is added.
Active Query Builder 3 Core Edition v.3.11.5.2254
= PostgreSQL: LATERAL and ONLY are added to the list of keywords.
Active Query Builder 3 Core Edition v.3.11.4.2253
= PostgreSQL: Keywords parsing as identifiers in aliases and field names is improved.
Active Query Builder 3 Core Edition v.3.11.3.2252
= Code cleanup, minor improvements are made.
Active Query Builder WinForms .NET Edition:
Active Query Builder WPF .NET Edition:
Active Query Builder ASP.NET Edition:
Active Query Builder Java Edition:
Active Query Builder ActiveX Edition:
Active Query Builder VCL Edition:
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!