Our team has worked with the Active Query Builder components since the middle of 2014.
By using Active Query Builder we have managed to upgrade our applications to the point where we can enable users with very little to no knowledge of SQL to access their databases and retrieve accurate summaries of their data. The component itself is flexible, easy to use, user friendly and consistently improved upon. Any issues that might occur are dealt with by a support team that sets the benchmark for customer service and professionalism.
In short, a superb product developed and supported by a superb team.
I have worked with the trial version for several weeks and I think your product is outstanding. The only thing I regret is not discovering Active Query Builder sooner.
Keep up the good work.
I have recently purchased Active Query Builder and incorporated it into my application. I found the process very easy and straight forward and apart from a issues relatively pain free. All issues I had during the process were quickly resolved by the support guys.
I have used a couple of other query builder components and by far
Really great work!
The best DB-Designtool I could found after lot of deep testings.
My users are happy now about the ability to create complicate sql-selects visually AND keep the freedom to edit the sql-code manually too (True 2-way-designing).
I was so impressed with its capability to handle subqueries and unions, no other competitors offer that. Eventhough I have bought for a such component (the ELS query designer)... I have to buy again this component... and replace the previous one.
I had many situations where I required some easy tool for end-users to create queries and reports. Over the years I evaluated a few query building engines, all look nice, but none was useful or could be implemented with db in use. Finally I tried out Active Query Builder, and it does everything I need, two days after evaluating I bought full version, and a few days later my customers already had their dream, a excellent query builder integrated completly with their db and report engine. Now they can extract their data in a easy way.
Many thanks for making such a good product.
After an extensive search for a viable set of components for Delphi to integrate a general purpose query tool into my applications, I have at last found what I am looking for.
The ANSI 92 compatibility will also allow me to use this with embedded RDBMS solutions like Vista 2.
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.
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, 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.