Active Query Builder 3 Core Edition v.3.7.2.1175
+ The installer creates local NuGet source with Active Query Builder packages.
Active Query Builder 3 Core Edition v.3.7.1.1174
+ Support for .Net Core 2.2 and 3.1 support has been added. - Snowflake SQL: LIMIT is treated as a valid identifier now. - Metadata calculation for virtual objects has been fixed. - Snowflake SQL: "POSITION" is removed from the keywords list. - Snowflake SQL: The ambiguity in the parsing of complex comparison expressions has been fixed.
Active Query Builder 3 Core Edition v.3.6.15.1172
= Metadata Editor: Minor error reporting fixes and improvements on loading data from XML files have been made. = Source code of the standard metadata providers (MS SQL Server, OLE DB, ODBC) has been added to all distributives. - Snowflake SQL: Keyword issues have been fixed. - PostgreSQL: Parsing of "TABLE.*" as a correct AST node at the top level of the SELECT clause has been fixed. - MySQL: Parsing of the "POSITION" clause has been fixed.
Active Query Builder 3 Core Edition v.3.6.14.1171
= Snowflake SQL: Support for the "WITHIN GROUP" clause has been added.
Active Query Builder 3 Core Edition v.3.6.13.1170
- Snowflake SQL: LimitCount and LimitOffset props are turned on to use the Skip and Take methods of the QueryTransformer.
Active Query Builder 3 Core Edition v.3.6.12.1169
- Snowflake SQL: Parsing of VARCHAR without char count has been fixed.
Active Query Builder 3 Core Edition v.3.6.11.1168
= The new method to append metadata from XML is added: MetadataContainer.AddFromXML(filename or stream). - Snowflake syntax: "LANGUAGE" is removed from the list of keywords. - SAP Hana: Minor SQL generation fixes are made. - MySQL: Minor fixes for queries with the "~" character.
Active Query Builder 3 Core Edition v.3.6.10.1167
= ODBCMetadataProvider: new properties are added to turn off some specific driver features that sometimes can improve the performance: IgnoreSchemaOnlyFlag and SkipLoadFieldsFromGetSchema. - MySQL: Logical conditions aren't suffixed with "=True" or "=False" anymore. - IBM DB2: System views are checked for existence before querying them.
Active Query Builder 3 Core Edition v.3.6.9.1166
+ Support for Snowflake DB SQL syntax has been added. - Assemblies are removed correctly now after uninstalling the product.
Active Query Builder 3 Core Edition v.3.6.6.1164
= QuickBooks: Support for square-brackets quoted identifiers has been added.
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!