Skip to main content
TrustRadius
Active Query Builder

Active Query Builder

Overview

What is Active Query Builder?

Active Query Builder is a component for business applications which helps users without any SQL experience to work with SQL queries and get data fast. Users can get a clear view of database schema and design SQL queries with natural…

Read more

Learn from top reviewers

Return to navigation

Pricing

View all pricing

VCL Edition (Delphi, C++Builder)

$199.00

On Premise
per developer

Core .NET Edition (non-visual)

$199.00

On Premise
per developer

ActiveX Edition

$299.00

On Premise
per developer

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.activequerybuilder.com/purc…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Details

What is Active Query Builder?

Active Query Builder is a component for business applications which helps users without any SQL experience to work with SQL queries and get data fast. Users can get a clear view of database schema and design SQL queries with natural point-and-click actions rather than tedious typing.

Active Query Builder assists novice users learning SQL and allows experienced users to analyze and understand their queries better by parsing them and building the visual diagram.

With Active Query Builder, programmers get full control over the user's queries to deny unauthorized data access so that it's safe to allow even non-technicians run SQL queries against the database.

Active Query Builder works with dozens of database servers, including Oracle, MS SQL Server, MySQL, PostgreSQL, DB2 and many others. It supports all popular SQL dialects and development environments. You can add it to various desktop and web projects .NET WinForms, WPF, WebForms, ASP.NET MVC, ASP.NET Core, Delphi, C++Builder, Java (Swing control), ActiveX.

Integration of Active Query Builder requires little attention from developers. The component's fine tuning can be performed later by an admin with the built-in setup module.

Active Query Builder Features

  • Supported: Possibility to combining visual query building with direct SQL text editing
  • Supported: SQL Text Editor with code completion and syntax highlighting
  • Supported: Preview of sub-query results during the visual query building process
  • Supported: SQL formatter to tune the view of your queries the way you like

Active Query Builder Technical Details

Deployment TypesOn-premise
Operating SystemsWindows
Mobile ApplicationMobile Web

Active Query Builder Customer Size Distribution

Consumers0%
Small Businesses (1-50 employees)70%
Mid-Size Companies (51-500 employees)25%
Enterprises (more than 500 employees)5%
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(8)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Active Query Builder has proven to be a valuable tool for users of all skill levels, from novices to experienced developers. Customers have praised its ability to provide a visual component that allows for easy creation of queries without requiring extensive SQL knowledge. The drag-and-drop functionality has made it particularly useful for non-IT professionals who can now customize their user experience by hiding or renaming database objects.

Integrating Active Query Builder into various software products has yielded positive feedback from customers, who have found significant added value in their programs. The flexibility and ease-of-use provided by the software have been particularly beneficial for business application development, enabling dynamic SQL query building and visual query creation.

Clients have found the Query Builder application to be both robust and intuitive, even without prior SQL query experience. Its ability to manipulate data and generate accurate summaries has been highly regarded. Additionally, the support team behind Active Query Builder has been commended for their promptness and professionalism in resolving any issues that arise.

With its straightforward design, powerful query manipulation capabilities, and responsive customer support, Active Query Builder comes highly recommended. It has played a key role in allowing users to easily create complex queries, enhancing the power and usability of their software applications. Furthermore, the product offers a safe way to extract data without compromising server access or user permissions.

For users with varying technical skills, the Query Builder component has been instrumental in SQL query development for dashboard purposes. Its flexibility and quality-of-life features have made it an effective tool for creating impactful data visuals. Overall, Active Query Builder has proven indispensable for retrieving data from SQL databases, especially for business users seeking to work with data and software effectively.

Useful Tool for SQL Queries: Active Query Builder has proven to be a valuable tool for users in preparing SQL queries for any database. Many reviewers have expressed their satisfaction with the ability to visually create queries and test them on different database servers.

Easy Data Transformation: Users highly appreciate the seamless data transformation capabilities of Active Query Builder. The software makes it easy to convert various file formats such as CSV, XML, Text, and Excel files into SQL format.

Constant Improvement and Responsive Support: Active Query Builder consistently receives positive feedback regarding its continuous improvement efforts. Reviewers find it impressive how the software caters to both newcomers and experienced professionals. Additionally, users praise the support team for their fast, friendly, and professional assistance with prompt responses on support tickets.

Code Completion Issues: Some users have reported experiencing problems with the code completion feature, finding it to be unreliable or inconsistent at times. This has led to frustration and inefficiency in their workflow.

Non-User-Friendly Dashboard: The dashboard of Active Query Builder has been consistently criticized by reviewers for its lack of user-friendliness and complexity. Many users have expressed a need for simplification and a more intuitive interface to enhance their overall experience with the software.

Challenges in Modifying SQL Queries: Several users have encountered difficulties when attempting to modify SQL queries using code within the software. These challenges have hindered their productivity and suggest room for improvement in terms of query modification capabilities.

Reviews

(1-5 of 5)

It makes it possible to create queries in a simple and fast way.

Rating: 9 out of 10
June 22, 2022
Vetted Review
Verified User
Active Query Builder
3 years of experience
We have used the Query Builder program for a few years now, and it has proven to be an excellent platform for querying databases. Clients who have never made a SQL query before may easily edit their data and obtain accurate summaries of their data in minutes because of the application's straightforward design and powerful query manipulation capabilities. In the unlikely event of a problem, you can reach a helpful support staff that consistently exceeds expectations in response time and expert-level service with just a quick email. Overall, it's a great program that you should try out.
  • Using the Query Builder, a large group of people may collaborate on dashboard development.
  • This is the place to be if you need to build SQL queries for any database.
  • Extraction data is made more secure by not requiring the formation of a user or the provisioning of access on the SQL server.
Cons
  • Improved query customization options.
  • Aside from some missing documentation, the features are solid.
  • Access control using either tokens or Jwt is a feature that may be enabled.
This is a good framework to use if your project requires frequent database queries. The product is made for both complete amateurs and seasoned experts. Prompt, courteous, and expert assistance; any problems are addressed and fixed without delay. Relatively inexpensive Inadequate, if there are new people involved, delays due to a lack of documentation are likely, and issues with code completion may arise.
  • Data integrity and loss prevention.
  • Quick response times for queries.
  • Database queries may now be executed quickly and easily.
  • It takes less time to teach experts because queries can be created easily.
  • Clearing out the technical departments was easier and had a greater effect on quality.
  • Since it allows users to see all of their data in one place while keeping it secure, Active Query Builder is the optimal choice.
In contrast, Active Query Builder was less expensive, more rapidly implemented, and received universally positive feedback from consumers. I have found that it is hard to anticipate all of the different ways that end users would want to query their data, and although I am not opposed to designing new views for end-users, it is important to keep in mind that the preferences of a single user will not be shared by all. Due to its complete visual access, Active Query Builder is the optimal choice.

Faster and safer query creation

Rating: 7 out of 10
March 10, 2022
Easy and safe way of SQL extraction is needed without actually allowing users access to SQL . Hence this allow users of a wide spectrum to write SQL queries for dashboards. we are using the Query Builder component to do exactly that use-case and it solves the requirement needed for our purpose.
  • Safer way of extracting data without creation of user or providing access on the Sql server
  • Using query builder to allow wide spectrum users to create dashboards
  • Review the risk of data corruption
Cons
  • More flexibility in query creation
  • Token based or Jwt access control as optional feature
  • More interactive analytical dashboards
Query creation is possible with being a sql server user, this is a well suited use-case for us. This helped us in controlling our user access on the sql servers. The major issue is safety auditing of data corruption on server, this way we are able to limit the data corruption .
  • Query builder without being user
  • Data safety and corruption risk elimination
  • Very fast query execution
  • Helped in data safety auditing
  • Dashboards help decision making better
  • Easy query creation reduces training time for professionals
I have used Flutter to begin and with flutter you need learn a language called Dart which is not needed with AQB, which is the main reason for us to pick Active Query Builder as a choice over Flutter. AQB supports all the merchant SQL databases with native syntax support, query optimizations and more

Active Query Builder - Great software for querying DB

Rating: 8 out of 10
March 07, 2022
KS
Vetted Review
Verified User
Active Query Builder
1 year of experience
It's a great framework to query databases, Our company has been using the Query Builder application for a couple of years at the time of writing. The application is robust enough to create and manipulate a wide array of queries yet intuitive so that clients who have never created a SQL query before can manipulate their data and generate accurate summaries of their data in minutes. Should any error occur, a support team that sets the standard in speed and professionalism is a mere email away. Overall, a highly recommended application
  • Easy to construct a SQL statement by using the drag/drop functionality. The after-sales support is amazing, the guys really go over and above to assist you."
  • Software is brilliant for all sorts of reporting we use it daily and do extremely complex SQL reports across MSSQL, PSQL, MySQL, and ODBC.
  • Very effective and easy to implement solution
  • If you want to prepare SQL queries for any database this is for you.
  • This provides another layer of security.
  • Review collected by and hosted on G2.com.
Cons
  • Features are good but lacks documentation
  • It would be great it were adaptive to Embarcadero/Dev Express Skins that would be very cool
  • Modifying SQL code is difficult
Suited 1) If the project involves lot querying to DB, this is apt framework 2). The product is designed to be used for anyone ranging from newcomers to professionals. Very fast, friendly, and professional service, if any issues are discovered they are quickly acknowledged and dealt with in a timely manner.3) Cost-effective Not suited - If there are new folks, lack of documentation will delay things, Sometimes code completion cause problems.
  • Simple and fast execution of querying DB
  • Exceptional customer support and feedback, to put it lightly
  • The 'SQLTextEditor' is a joy to behold offering not only good syntax highlighting but SQL IntelliSense as well (particularly useful for SQL novices)."
  • The tech depts were cleared faster and had high impact on quality
  • Active Query Builder is the perfect solution, providing comprehensive visual access to data in a safe and controlled environment.
AQB for cheap, faster to market, and reviews were really good. It has proved impossible for me to predict every which way that end users would want to query their data and whilst I'm not averse to creating new views for end-users one person's wishes will not always suit everyone else's. Active Query Builder is the perfect solution, providing comprehensive visual access t
Corcentric Source-to-Pay Platform (Determine / Selectica), Flutter, by Google, JobProgress

Active Query Builder - a powerful handy little tool!

Rating: 9 out of 10
March 02, 2022
Vetted Review
Verified User
Active Query Builder
10 years of experience
It is a query tool for retrieving data from SQL for users even without any SQL database experience. It is best suited for business users who work on data and software dealing with SQL databases. It gives a clear view of the database schema. Unfortunately, it does not have a free version hence I will give a 9!
  • Pull data from SQL even if you do not know SQL.
  • Provides clear database information.
  • Works with multiple databases at once.
  • Data access and security.
Cons
  • Pricing - no free version..they should provide one for evaluation.
  • Not so easy to use core SQL function for end users.
  • It can be more user friendly or may be more of user guidance providing tips to users.
  • And perhaps a better documentation of the product.
It is a good one for business users who are in no way technical and do not have any insights about the backend databases and do not have any SQL experience. They can simply go in and create queries without any SQL knowledge by just using a drag and drop way..now tell me how cool is that? :)
  • It's ease of use or user friendly.
  • Features are good..can be improved.
  • Integration which can be quick.
  • Active Query Builder provides a safe way of extracting data without actually creating users or granting user access.
  • And the above point gives another layer of security.
  • With no or little technical knowledge any one can create custom reports.
It's good quality software, simple to use, support is also great. It's easy to get started and the integration is also easy. Security-wise it's the best and the usage as compared to the security is by large the best and for end users with no technical knowledge, it's a great thing.

Great Tool for creating robust queries

Rating: 9 out of 10
March 02, 2022
Vetted Review
Verified User
Active Query Builder
1 year of experience
active query builder allows our company to centralize the data into a warehouse and then allows us to build awesome data visuals which in turn makes for better business decisions
  • quick data visuals
  • better business decisions
Cons
  • user interface
primarily for orgs with a lot of data that is not centralized, this helps visualize data that is not easily accessible
  • providing a user friendly environment to create sql queries
  • users ability to use this tool with limited sql knowledge
  • better business decisions allow us to maximize revenue for the company
  • awesome ROI
it seemed more user friendly out of the box
Return to navigation