Active Query Builder

A shortcut to your data
  • WinForms
  • ASP.NET
  • Java
  • Delphi
  • WPF
  • ActiveX
Online SQL Query Builder - See in action!

Usage scenarios

  • Ad-hoc reporting
    • Let users query your database to get data they need right now.
    • Embed visual query builder into your report system to allow precise data selection for custom reports.
  • Data filtration
    • Let users define filters for database object fields and columns of the given query via handy tree-like control.
    • Change sorting and calculate totals for a given dataset.
  • Data import
    • Connect to external database
    • Build SQL queries to extract data
    • Map query columns to fields of internal database objects for data import
Active Query Builder is a component for software developers to let users build SQL queries visually and get data from SQL databases fast and safe.

Active Query Builder is a full-featured suite for programmers to deal with SQL queries and make database schema clear for end-users. It has powerful SQL parser and API to analyse, modify and build new queries from scratch.

Active Query Builder works with any database server; supports dozens of SQL dialects

Active Query Builder generates standardized SQL queries with regard to a certain database management system. You no longer need to worry about "tiny" proprietary syntax differences that sometimes cause errors.

Teradata, SAP HANA, Informix, Netezza, Firebird, Pervasive and many others...

Download Demo Version Now!
Request Demo Version Now!

Active Query Builder is made for

  • Developers
    • Enable ad-hoc reporting to business users
    • Provide users with safe access to data
    • Set up dataflow in your application the way you need
  • DB Admins
    • Control data access permissions while querying data at all levels: objects, fields, and records
    • Analyze SQL queries and understand complex structures
  • Database Users
    • Get data in seconds
    • Build queries fast without SQL knowledge
    • Visualise SQL queries and database schema as a diagram
Request Detailed Information

Get Data From SQL Databases Fast & Safe

Searching data in a database

Active Query Builder provides easy access to data inside of SQL databases for users with any level of experience in SQL and database management. Build queries with intelligent drag'n'drop rather than tedious typing.

Integration with your software solution takes just a few minutes, so users can pull the required data right away to handle business tasks without hitting a wall.

Build a bridge to your data and access it on a regular basis like an Excel spreadsheet

Make data-based decision times faster,
and be more productive!

  • Instant data browsing: the data is shown as you build a query
  • No more mistakes: forget about searching for a missing comma
  • Helpful tips and error notifications for confident work with SQL queries
Build a bridge to your data and access it on a regular basis like an Excel spreadsheet
Download Demo Version Now!
Request Demo Version Now!
  • Coming soon

The component will be available as a cloud service or containerized hosted solution in a few months.
Subscribe now to stay informed.

Safe way to get access to data

When using Active Query Builder, you make access to your databases safe for non-technicians. With the right permissions, business users won't do any harm to your data, and they'll perform regular tasks without constant supervision.

It's also safe to let more experienced users write SQL queries by hand. Active Query Builder eliminates the chance of human error and protects your database from SQL injection and unauthorized access by parsing and analyzing all incoming queries.

Make SQL queries an open book

Active Query Builder will be a great teaching assistant for learning SQL. It'll help your customers or employees master SQL faster, and reduce your teaching costs.

While beginners prefer to use a visual SQL query builder as an essential assistant, professionals can still enjoy writing SQL queries in a traditional way, but be able to switch to the visual designer to look at things from another perspective.

Visual query builder

Active Query Builder will be a great teaching assistant for learning SQL. It'll help your customers or employees master SQL faster, and reduce your teaching costs.

Analyzing SQL queries
Sergey Smagin CEO & Founder
Our main task is to make data access equally available for both beginners and professionals, while providing developers with a convenient tool for managing SQL queries

Fine-tune to match your needs

Setting up Active Query Builder requires little attention from developers. Additional customization helps you represent your database schema to fit your needs and tune the module's UI the way you need.


We'll be happy to help you with custom Active Query Builder implementation. We assign experienced developers and managers to this task. The project evaluation is free.

  • 100% money-back guarantee

Premium assistance

As a part of our consulting services, we can teach your employees how to use our software or connect to your computers via remote access to set everything up.

Request for Assistance

Active Database Software:

  • Trusted data access systems
  • 13 years of experience
  • 2,000 customers around the globe

Testimonials

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.

Rating: (5 out of 5)

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

... 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!

Rating:

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.

Rating: (5 out of 5)

News

Blog

Tweets

PRODUCT
ABOUT US
SUPPORT
FOR CUSTOMERS
© Copyright 2005-2018 ActiveDBSoft. All rights reserved.
Choose Edition
Active Query Builder WinForms and WPF Editions Native WinForms and WPF component, for .NET 4.0+
with the optional support of DevExpress WinForms controls
Active Query Builder ASP.NET Edition Web component for WebForms, ASP.NET MVC and Core with client or server-side rendering
Active Query Builder Java Edition Swing-based Java bean component for all modern Java development environments
Active Query Builder ActiveX Edition ActiveX control (COM object) for wide range of development environments
Active Query Builder VCL Edition Delphi and C++ Builder component suite for VCL or DevExpress VCL libraries
End-user SQL Query Tool for Windows Build SQL queries and work with data with dozens of database servers
Demo Version Download

You're about to download the Active Query Builder Demo for your project.

The demo can be installed only on a desktop PC. We can send you the download link to your e-mail.

Send me Active Query Builder news from time to time.
Active Query Builder Demo doesn't have time or functional limitations, it just adds random aliases for query output columns to the query text.
Thank you!
We've just sent the message with the link to your e-mail address.
Please check the SPAM folder if you don't receive it.
Your download will begin shortly. If it doesn't start automatically, click on this
Need help getting started?
We can help you to start using SQL Active Query Builder quickly in 5 short emails!
Get guide No, thanks
Support
Thank you!
We will answer your question as quick as possible, but not later than in 24 hours, In the case you don't receive it, please check for the answer in our support ticket system
Ok
Close
Help
Active Query Builder ASP.NET Edition in action
×
How to work with this
demo?
  • To build a query visually:
    • Drag tables from the Database Schema View at the left to the Design Pane.
    • Add more tables by clicking on the link buttons next to fields in existing tables.
    • Check table fields you want to see as output columns of your query.
    • Specify names, sorting, grouping and conditions for the query columns via the Query Columns Grid.
  • Edit the query text on the SQL Text tab and update the visual diagram in one click.
  • Load one of the predefined sample queries on the Queries tab.