--- description: Learn more about Active Query Builder price, benefits, and disadvantages for businesses in New Zealand. Read verified software reviews and find tools that fit your business needs. image: https://gdm-localsites-assets-gfprod.imgix.net/images/capterra/og_logo-e5a8c001ed0bd1bb922639230fcea71a.png?auto=format%2Cenhance%2Ccompress title: Active Query Builder Pricing, Reviews & Features - Capterra New Zealand 2026 --- Breadcrumb: [Home](/) > [Database Software](/directory/18/database-management/software) > [Active Query Builder](/software/176087/active-query-builder) # Active Query Builder Canonical: https://www.capterra.co.nz/software/176087/active-query-builder Page: 1 / 2\ Next: [Next page](https://www.capterra.co.nz/software/176087/active-query-builder?page=2) > A component to build SQL queries via the intuitive drag'n'drop interface for users with no SQL experience to enable safe access to data > > Verdict: Rated **4.7/5** by 15 users. Top-rated for **Likelihood to recommend**. ----- ## Overview ### Who Uses Active Query Builder? Business application developers who work on a software dealing with SQL databases. ## Quick Stats & Ratings | Metric | Rating | Detail | | **Overall** | **4.7/5** | 15 Reviews | | Ease of Use | 4.2/5 | Based on overall reviews | | Customer Support | 4.7/5 | Based on overall reviews | | Value for Money | 4.8/5 | Based on overall reviews | | Features | 4.8/5 | Based on overall reviews | | Recommendation percentage | 90% | (9/10 Likelihood to recommend) | ## About the vendor - **Company**: Active Database Software - **Founded**: 2005 ## Commercial Context - **Starting Price**: CA$199.00 - **Pricing model**: Flat Rate (Free Trial) - **Pricing Details**: Lifetime license with 1 year of priority support and free upgrades. - **Target Audience**: Self Employed, 2–10, 11–50, 51–200, 201–500, 501–1,000, 1,001–5,000, 5,001–10,000, 10,000+ - **Deployment & Platforms**: Windows (Desktop) - **Available Countries**: Canada ## Features - Multiple Programming Languages Supported ## Support Options - Chat ## Category - [Database Software](https://www.capterra.co.nz/directory/18/database-management/software) ## Alternatives 1. [Microsoft SQL Server](https://www.capterra.co.nz/software/1417/sql-server) — 4.6/5 (1975 reviews) 2. [MySQL](https://www.capterra.co.nz/software/11482/mysql) — 4.6/5 (2094 reviews) 3. [Airtable](https://www.capterra.co.nz/software/146652/airtable) — 4.6/5 (2227 reviews) 4. [Microsoft Access](https://www.capterra.co.nz/software/1015743/microsoft-access) — 4.4/5 (205 reviews) 5. [Google Cloud](https://www.capterra.co.nz/software/170983/google-cloud-platform) — 4.7/5 (2269 reviews) ## Reviews ### "Great Database querying tool" — 4.0/5 > **Alvin** | *11 January 2024* | Computer Software | Recommendation rating: 8.0/10 > > **Pros**: The user interface is fantasticc and the software is one of a kind in the market. > > **Cons**: Since Nuget has become popular it always goes into demo mode when I clone a git repository and Visual Studio updates the Nuget packages. This is because they store the DEMO versions on nuget.org. This is HORRIBLE\! I have to go through headache after headache trying to get out of demo mode. > > I have used AQB for 20 years or so since it's inception. Once the product is installed and working it is a great development tool. I jusst wish they would make nuget.org for the release / licenssed version. ----- ### "Simply ... a stunning piece of software for querying databases" — 5.0/5 > **Dom** | *27 August 2018* | Computer Software | Recommendation rating: 10.0/10 > > **Pros**: From a developers perspective this tool is a joy to use, allowing simple drag and drop use (with very little code behind required) to a very customisable tool that can be fully integrated into your own application's environment. It allows you to provide your own end users with the freedom to interrogate their own data using a simple yet familiar visual paradigm or, for those who actually posses a good working knowledge of SQL the ability to create really quite complex queries to answer their specific needs, needs which I, as the application developer might not have even considered that they wanted. The 'SQLTextEditor' is a joy to behold offering not only good syntax highlighting but SQL intellisense as well (particularly useful for SQL novices). Equally impressive is the ability of the tool to allow you to create a textual query and then have it produce a visual representation of it. Within a very short time of trialing this you'll realise just what a superb tool you have found, and at the same time be cursing yourself for not having discovered it sooner. If you are looking for a way to allow your end users access to the database that holds the data your application is creating on their behalf that can is intuitively simple to use then look no further. > > **Cons**: If I were to voice one criticism it would be that the documentation is perhaps not yet as comprehensive as it might be, although in fairness that is a failure acknowledged by the vendor themselves and is being corrected. However that isn't in reality that big a deal as the support that they offer is superb and that, from the perspective of a developer using a third party component, is worth it's weight in gold. > > I have an application that uses a very complex underlying database. 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 persons wishes will not always suit everyone else's. Active Query Builder is the perfect solution, providing comprehensive visual access to data in a safe and controlled environment. ----- ### "Very useful to give non IT professionals the ability to create queries." — 5.0/5 > **Ralf** | *28 May 2019* | Program Development | Recommendation rating: 10.0/10 > > **Pros**: Before we chose AQB, we tested several other programs of this kind. We were convinced by the following points: + The integration into our program was really very simple and took less than 10 minutes. + You can change the names of database objects and fields using a mapper. For example, database objects can be hidden from the end-user or more user-friendly names can be assigned. (By the way, that's a big point for us.) + The user interface can be adapted very well and with little effort. + The Visual Designer can also be used intuitively by "normal end-users" after a very brief introduction. + In the very few cases in which we needed support, we were helped very quickly and competently. The support was so fast that it reminds more of a chat than an e-mail conversation. > > **Cons**: I've really been thinking for a few minutes about what to put in this field. But there is really nothing here that I could criticize. Maybe the documentation isn't perfect, but the software is so intuitive and the support is really good. Then I can do without a documentation that is 100%. > > We have developed software for a specific industry. This industry uses our software to manage their services, goods receipts, goods issues and invoices. Of course, good reporting is also required. Unfortunately, we were unable to meet the very different reporting requirements of all our customers. At the same time, it was impossible for our customers to write SQL statements themselves because they are not IT professionals. By using AQB we were able to integrate a visual component into our program that allows our customers to create queries without SQL knowledge, but only by drag-and-drop. By hiding or renaming database objects, we were able to hide unimportant tables for the user or give fields more understandable names for the user. By the way: you can also add a ToolTip to fields. We have received a very positive response from our customers. Our program has received a significant added value through the integration of AQB. ----- ### "Good but undocumented" — 4.0/5 > **Pavel** | *16 May 2019* | Computer Software | Recommendation rating: 5.0/10 > > **Pros**: Good interface, a lot of features, rich object model. > > **Cons**: No documentation for the version 3. Support team answers quickly though. ----- ### "Great product\! Real value for money\!" — 4.0/5 > **Shrenik** | *31 May 2018* | Information Technology & Services | Recommendation rating: 10.0/10 > > **Pros**: The client did not had any way of extracting data directly from the database. With AQB and a little technical knowledge the client can themselves create custom reports as per their requirement. Previously the client had to spend money for the generating the reports and also had to wait until the reports are coded. AQB provides a safe way of extracting data without actually creating user or granting user access on the server. This provides another layer of security. Prompt responses on the support tickets. > > **Cons**: It's common for there to be small bugs in each new release. With each upgrade, we have to open a ticket with AQB to get the issues resolved. It would be helpful if AQB is made compitable with Bootstrap. Hard to find solutions for the issues faced during integrations in the documentation provided by AQB. ----- Page: 1 / 2\ Next: [Next page](https://www.capterra.co.nz/software/176087/active-query-builder?page=2) ## Links - [View on Capterra](https://www.capterra.co.nz/software/176087/active-query-builder) ## This page is available in the following languages | Locale | URL | | de | | | de-AT | | | de-CH | | | en | | | en-AE | | | en-AU | | | en-CA | | | en-GB | | | en-IE | | | en-IL | | | en-IN | | | en-NZ | | | en-SG | | | en-ZA | | | fr | | | fr-BE | | | fr-CA | | | fr-LU | | ----- ## Structured Data