Active Query Builder

SQL Query Builder

Full feature matrix


Full feature list of Active Query Builder WinForms and WPF Edition

Feature FreeStand.Prof.Core
Main features
Visual SQL query builder
A user interface for designing the most complex SQL queries. Most operations are performed with a few mouse clicks or using drag-and-drop.
YES
YES
YES
NO
SQL query parser
Parsing of the most complex SELECT statements, building their object model for further analysis and modification.
YES
YES
YES
YES
SQL query reverse engeneering
Building a diagram of parsed SQL queries for visual representation of complex SQL query structures.
YES
YES
YES
N/A *
Two-way SQL query building
Instant switching between visual query building and direct SQL text editing at any time.
YES
YES
YES
N/A *
Customizable SQL text formatter
Plenty of settings to tune the formatting of your queries to your taste.
YES
YES
YES
YES
Visual SQL filter builder
A visual user interface to add WHERE conditions to columns of the original SQL query.
NO
YES
YES
N/A *
Full support of dozens of SQL dialects
The free version only supports basic SQL syntax constructs defined in the ANSI SQL standards. The paid versions support all the peculiarities of each SQL dialect. See the list of supported dialects.
No **
YES
YES
YES
Programming creation, analysis and editing of SQL queries
A full-featured API lets you create complex SQL queries from scratch, analyze and modify any part of your queries.
NO
YES
YES
YES
Advanced SQL text editor
An SQL text editor with code completion and syntax highlighting.
NO
NO
YES
N/A *
Visual Interface
Easy navigation across complex query structures
Visual representation and editing of the SQL query structure with unions, sub-queries, derived tables and Common Table Expressions (WITH clause).
YES
YES
YES
N/A *
Visual building of every single part of a SELECT query
Visual setting of grouping, ordering and filtering options for query columns and custom SQL expressions.
YES
YES
YES
N/A *
Quick search for database objects
Search and filtering by objects in the Database Schema Tree.
YES
YES
YES
N/A *
Automatic joining of tables in a query
Objects in a query are joined automatically according to the information about the database schema (foreign keys).
YES
YES
YES
N/A *
Manual creation of links between objects in a query
Joins between objects can be created by dragging-and-dropping fields from one object on the Design Pane to another.
YES
YES
YES
N/A *
Joining tables indirectly linked with each other
Automatic creation of intermediate tables upon adding a new table to a query for joining with existing tables.
YES
YES
YES
N/A *
Visual setting of specific properties of various query elements
Easy definition of data source aliases, join types, and various query properties, such as TOP/LIMIT, DISTINCT, etc.
NO
YES
YES
N/A *
Advanced SQL expression editor
Ease of typing complex SQL expressions with the help of a multiline text editor with code completion, syntax highlighting and lookup lists of objects, fields and functions.
NO
NO
YES
N/A *
Creating a user-friendly query building environment
Convenient names for database objects and fields
User-friendly names can be used during the visual query building process, as well as for direct SQL text editing. Their substitution for real names is performed invisibly for the end-user.
NO
YES
YES
YES
Virtual objects
Adding new objects to the database schema that appear identical to ordinary objects to the user in a visual and text query representation, and that turn into derived tables when the query is executed.
NO
YES
YES
YES
Calculated fields
Adding new fields to the list of database object fields that have no difference from ordinary fields to the user, which turn into SQL expressions or correlated sub-queries when the query is executed.
NO
YES
YES
YES
Reorganizing the Database Schema view tree structure
Possibility to simply change the way of grouping objects within the tree, as well as their complete regrouping in accordance with the logical data structure; adding new nodes to the dynamic tree structure.
NO
YES
YES
N/A *
Saving the query diagram layout between work sessions
User can continue its job exactly where he/she has stopped. Sizes and positions of objects on the query diagram will be kept untouched.
NO
YES
YES
N/A *
Editing of sub-query text separately from the whole query
The text of any single sub-query can be accessed and changed separately from the whole query. Special events allow for interrupting visual changes to correct or cancel incorrect changes of sub-query text.
NO
YES
YES
N/A *
Repository of reusable queries
A special visual UI snippet lets save and edit SQL queries in the internal repository, with the possibility to use these queries just like views in subsequent queries.
NO
NO
YES
N/A *
Decomposable visual user interface
Possibility to decompose and customize the user interface by adding, removing, and reorganizing visual controls.
NO
NO
YES
N/A *
Database Schema handling
Automatic Database Schema extraction
Automatic extraction of the Database Schema is performed partially and on demand, taking into account the peculiarities of their representation for the given database server.
YES
YES
YES
YES
Metadata pre-filtering, hiding of unwanted objects
Partial metadata loading using filters to speed up initialization; programmatic hiding of unwanted objects from the user.
NO
YES
YES
YES
Programmatic filling of the metadata container
Objects can be added programmatically in case of a non-standard connection to the database (three-tier architecture, web service, etc.)
NO
YES
YES
YES
Saving and loading of metadata into the XML format
Loaded metadata can be cached to XML format to speed-up further metadata loading or to decrease the database server load.
NO
YES
YES
YES
Working without a live database connection
No live database connection is required in case of loading metadata from XML. It's possible to work with limited functionality without loading metadata.
NO
YES
YES
YES
Application Programming Interface
API for making additional changes to ready SQL queries
A handy API for applying additional filters, sorting, pagination to a query and retrieving totals to allow for a feature-rich user interface while browsing the query result.
NO
YES
YES
YES
Prevention of the execution of queries with unwanted objects
Checking a query for forbidden objects before its execution is possible without loading its visual representation and even without loading the database schema.
NO
YES
YES
YES
Programmatic SQL query analysis and modification
Full access to the internal query object model for programmatic SQL query analysis and modification.
NO
YES
YES
YES
Information about the parameters found in a query
Retrieval of the list of parameters found in a query and useful details about them: data type, related field, operator.
NO
YES
YES
YES
Summary information about a query
Information about database objects and fields, output columns in the query is instantly available for the entire query, and for each sub-query and SQL expression.
NO
YES
YES
YES
Miscellaneous options
Localization of the user interface
Possibility to translate the interface of Active Query Builder into any language. Dozens of localizations available out-of-the-box.
YES
YES
YES
N/A *
Database server autodetection
Possibility to detect the SQL Syntax dialect upon connecting to a database server.
NO
YES
YES
YES

Full feature list of Active Query Builder ASP.NET Edition

Feature Stand.
Main features
Visual SQL query builder
A user interface for designing the most complex SQL queries. Most operations are performed with a few mouse clicks or using drag-and-drop.
YES
SQL query parser
Parsing of the most complex SELECT statements, building their object model for further analysis and modification.
YES
SQL query reverse engeneering
Building a diagram of parsed SQL queries for visual representation of complex SQL query structures.
YES
Two-way SQL query building
Instant switching between visual query building and direct SQL text editing at any time.
YES
Customizable SQL text formatter
Plenty of settings to tune the formatting of your queries to your taste.
YES
Visual SQL filter builder
A visual user interface to add WHERE conditions to columns of the original SQL query.
YES
Full support of dozens of SQL dialects
The free version only supports basic SQL syntax constructs defined in the ANSI SQL standards. The paid versions support all the peculiarities of each SQL dialect. See the list of supported dialects.
YES
Programming creation, analysis and editing of SQL queries
A full-featured API lets you create complex SQL queries from scratch, analyze and modify any part of your queries.
YES
Visual Interface
Easy navigation across complex query structures
Visual representation and editing of the SQL query structure with unions, sub-queries, derived tables and Common Table Expressions (WITH clause).
YES
Visual building of every single part of a SELECT query
Visual setting of grouping, ordering and filtering options for query columns and custom SQL expressions.
YES
Quick search for database objects
Search and filtering by objects in the Database Schema Tree.
YES
Automatic joining of tables in a query
Objects in a query are joined automatically according to the information about the database schema (foreign keys).
YES
Manual creation of links between objects in a query
Joins between objects can be created by dragging-and-dropping fields from one object on the Design Pane to another.
YES
Joining tables indirectly linked with each other
Automatic creation of intermediate tables upon adding a new table to a query for joining with existing tables.
YES
Visual setting of specific properties of various query elements
Easy definition of data source aliases, join types, and various query properties, such as TOP/LIMIT, DISTINCT, etc.
YES
Creating a user-friendly query building environment
Convenient names for database objects and fields
User-friendly names can be used during the visual query building process, as well as for direct SQL text editing. Their substitution for real names is performed invisibly for the end-user.
YES
Virtual objects
Adding new objects to the database schema that appear identical to ordinary objects to the user in a visual and text query representation, and that turn into derived tables when the query is executed.
YES
Calculated fields
Adding new fields to the list of database object fields that have no difference from ordinary fields to the user, which turn into SQL expressions or correlated sub-queries when the query is executed.
YES
Reorganizing the Database Schema view tree structure
Possibility to simply change the way of grouping objects within the tree, as well as their complete regrouping in accordance with the logical data structure; adding new nodes to the dynamic tree structure.
YES
Saving the query diagram layout between work sessions
User can continue its job exactly where he/she has stopped. Sizes and positions of objects on the query diagram will be kept untouched.
YES
Editing of sub-query text separately from the whole query
The text of any single sub-query can be accessed and changed separately from the whole query. Special events allow for interrupting visual changes to correct or cancel incorrect changes of sub-query text.
YES
Decomposable visual user interface
Possibility to decompose and customize the user interface by adding, removing, and reorganizing visual controls.
YES
Database Schema handling
Automatic Database Schema extraction
Automatic extraction of the Database Schema is performed partially and on demand, taking into account the peculiarities of their representation for the given database server.
YES
Metadata pre-filtering, hiding of unwanted objects
Partial metadata loading using filters to speed up initialization; programmatic hiding of unwanted objects from the user.
YES
Programmatic filling of the metadata container
Objects can be added programmatically in case of a non-standard connection to the database (three-tier architecture, web service, etc.)
YES
Saving and loading of metadata into the XML format
Loaded metadata can be cached to XML format to speed-up further metadata loading or to decrease the database server load.
YES
Working without a live database connection
No live database connection is required in case of loading metadata from XML. It's possible to work with limited functionality without loading metadata.
YES
Application Programming Interface
API for making additional changes to ready SQL queries
A handy API for applying additional filters, sorting, pagination to a query and retrieving totals to allow for a feature-rich user interface while browsing the query result.
YES
Prevention of the execution of queries with unwanted objects
Checking a query for forbidden objects before its execution is possible without loading its visual representation and even without loading the database schema.
YES
Programmatic SQL query analysis and modification
Full access to the internal query object model for programmatic SQL query analysis and modification.
YES
Information about the parameters found in a query
Retrieval of the list of parameters found in a query and useful details about them: data type, related field, operator.
YES
Summary information about a query
Information about database objects and fields, output columns in the query is instantly available for the entire query, and for each sub-query and SQL expression.
YES
Miscellaneous options
Localization of the user interface
Possibility to translate the interface of Active Query Builder into any language. Dozens of localizations available out-of-the-box.
YES
Database server autodetection
Possibility to detect the SQL Syntax dialect upon connecting to a database server.
YES

Full feature list of Active Query Builder Java Edition

Feature FreeStand.
Main features
Visual SQL query builder
A user interface for designing the most complex SQL queries. Most operations are performed with a few mouse clicks or using drag-and-drop.
YES
YES
SQL query parser
Parsing of the most complex SELECT statements, building their object model for further analysis and modification.
YES
YES
SQL query reverse engeneering
Building a diagram of parsed SQL queries for visual representation of complex SQL query structures.
YES
YES
Two-way SQL query building
Instant switching between visual query building and direct SQL text editing at any time.
YES
YES
Customizable SQL text formatter
Plenty of settings to tune the formatting of your queries to your taste.
YES
YES
Full support of dozens of SQL dialects
The free version only supports basic SQL syntax constructs defined in the ANSI SQL standards. The paid versions support all the peculiarities of each SQL dialect. See the list of supported dialects.
No **
YES
Programming creation, analysis and editing of SQL queries
A full-featured API lets you create complex SQL queries from scratch, analyze and modify any part of your queries.
NO
YES
Visual Interface
Easy navigation across complex query structures
Visual representation and editing of the SQL query structure with unions, sub-queries, derived tables and Common Table Expressions (WITH clause).
YES
YES
Visual building of every single part of a SELECT query
Visual setting of grouping, ordering and filtering options for query columns and custom SQL expressions.
YES
YES
Quick search for database objects
Search and filtering by objects in the Database Schema Tree.
YES
YES
Automatic joining of tables in a query
Objects in a query are joined automatically according to the information about the database schema (foreign keys).
YES
YES
Manual creation of links between objects in a query
Joins between objects can be created by dragging-and-dropping fields from one object on the Design Pane to another.
YES
YES
Visual setting of specific properties of various query elements
Easy definition of data source aliases, join types, and various query properties, such as TOP/LIMIT, DISTINCT, etc.
NO
YES
Creating a user-friendly query building environment
Convenient names for database objects and fields
User-friendly names can be used during the visual query building process, as well as for direct SQL text editing. Their substitution for real names is performed invisibly for the end-user.
NO
YES
Virtual objects
Adding new objects to the database schema that appear identical to ordinary objects to the user in a visual and text query representation, and that turn into derived tables when the query is executed.
NO
YES
Calculated fields
Adding new fields to the list of database object fields that have no difference from ordinary fields to the user, which turn into SQL expressions or correlated sub-queries when the query is executed.
NO
YES
Saving the query diagram layout between work sessions
User can continue its job exactly where he/she has stopped. Sizes and positions of objects on the query diagram will be kept untouched.
NO
YES
Database Schema handling
Automatic Database Schema extraction
Automatic extraction of the Database Schema is performed partially and on demand, taking into account the peculiarities of their representation for the given database server.
YES
YES
Metadata pre-filtering, hiding of unwanted objects
Partial metadata loading using filters to speed up initialization; programmatic hiding of unwanted objects from the user.
NO
YES
Programmatic filling of the metadata container
Objects can be added programmatically in case of a non-standard connection to the database (three-tier architecture, web service, etc.)
NO
YES
Saving and loading of metadata into the XML format
Loaded metadata can be cached to XML format to speed-up further metadata loading or to decrease the database server load.
NO
YES
Working without a live database connection
No live database connection is required in case of loading metadata from XML. It's possible to work with limited functionality without loading metadata.
NO
YES
Application Programming Interface
API for making additional changes to ready SQL queries
A handy API for applying additional filters, sorting, pagination to a query and retrieving totals to allow for a feature-rich user interface while browsing the query result.
NO
YES
Prevention of the execution of queries with unwanted objects
Checking a query for forbidden objects before its execution is possible without loading its visual representation and even without loading the database schema.
NO
YES
Programmatic SQL query analysis and modification
Full access to the internal query object model for programmatic SQL query analysis and modification.
NO
YES
Information about the parameters found in a query
Retrieval of the list of parameters found in a query and useful details about them: data type, related field, operator.
NO
YES
Summary information about a query
Information about database objects and fields, output columns in the query is instantly available for the entire query, and for each sub-query and SQL expression.
NO
YES
Miscellaneous options
Localization of the user interface
Possibility to translate the interface of Active Query Builder into any language. Dozens of localizations available out-of-the-box.
YES
YES
Database server autodetection
Possibility to detect the SQL Syntax dialect upon connecting to a database server.
NO
YES

Full feature list of Active Query Builder VCL Edition

Feature FreeStand.
Main features
Visual SQL query builder
A user interface for designing the most complex SQL queries. Most operations are performed with a few mouse clicks or using drag-and-drop.
YES
YES
SQL query parser
Parsing of the most complex SELECT statements, building their object model for further analysis and modification.
YES
YES
SQL query reverse engeneering
Building a diagram of parsed SQL queries for visual representation of complex SQL query structures.
YES
YES
Two-way SQL query building
Instant switching between visual query building and direct SQL text editing at any time.
YES
YES
Customizable SQL text formatter
Plenty of settings to tune the formatting of your queries to your taste.
YES
YES
Full support of dozens of SQL dialects
The free version only supports basic SQL syntax constructs defined in the ANSI SQL standards. The paid versions support all the peculiarities of each SQL dialect. See the list of supported dialects.
No **
YES
Programming creation, analysis and editing of SQL queries
A full-featured API lets you create complex SQL queries from scratch, analyze and modify any part of your queries.
NO
YES
Visual Interface
Easy navigation across complex query structures
Visual representation and editing of the SQL query structure with unions, sub-queries, derived tables and Common Table Expressions (WITH clause).
YES
YES
Visual building of every single part of a SELECT query
Visual setting of grouping, ordering and filtering options for query columns and custom SQL expressions.
YES
YES
Quick search for database objects
Search and filtering by objects in the Database Schema Tree.
YES
YES
Automatic joining of tables in a query
Objects in a query are joined automatically according to the information about the database schema (foreign keys).
YES
YES
Manual creation of links between objects in a query
Joins between objects can be created by dragging-and-dropping fields from one object on the Design Pane to another.
YES
YES
Visual setting of specific properties of various query elements
Easy definition of data source aliases, join types, and various query properties, such as TOP/LIMIT, DISTINCT, etc.
NO
YES
Creating a user-friendly query building environment
Convenient names for database objects and fields
User-friendly names can be used during the visual query building process, as well as for direct SQL text editing. Their substitution for real names is performed invisibly for the end-user.
NO
YES
Virtual objects
Adding new objects to the database schema that appear identical to ordinary objects to the user in a visual and text query representation, and that turn into derived tables when the query is executed.
NO
YES
Calculated fields
Adding new fields to the list of database object fields that have no difference from ordinary fields to the user, which turn into SQL expressions or correlated sub-queries when the query is executed.
NO
YES
Saving the query diagram layout between work sessions
User can continue its job exactly where he/she has stopped. Sizes and positions of objects on the query diagram will be kept untouched.
NO
YES
Editing of sub-query text separately from the whole query
The text of any single sub-query can be accessed and changed separately from the whole query. Special events allow for interrupting visual changes to correct or cancel incorrect changes of sub-query text.
NO
YES
Database Schema handling
Automatic Database Schema extraction
Automatic extraction of the Database Schema is performed partially and on demand, taking into account the peculiarities of their representation for the given database server.
YES
YES
Metadata pre-filtering, hiding of unwanted objects
Partial metadata loading using filters to speed up initialization; programmatic hiding of unwanted objects from the user.
NO
YES
Programmatic filling of the metadata container
Objects can be added programmatically in case of a non-standard connection to the database (three-tier architecture, web service, etc.)
NO
YES
Saving and loading of metadata into the XML format
Loaded metadata can be cached to XML format to speed-up further metadata loading or to decrease the database server load.
NO
YES
Working without a live database connection
No live database connection is required in case of loading metadata from XML. It's possible to work with limited functionality without loading metadata.
NO
YES
Application Programming Interface
API for making additional changes to ready SQL queries
A handy API for applying additional filters, sorting, pagination to a query and retrieving totals to allow for a feature-rich user interface while browsing the query result.
NO
YES
Prevention of the execution of queries with unwanted objects
Checking a query for forbidden objects before its execution is possible without loading its visual representation and even without loading the database schema.
NO
YES
Programmatic SQL query analysis and modification
Full access to the internal query object model for programmatic SQL query analysis and modification.
NO
YES
Information about the parameters found in a query
Retrieval of the list of parameters found in a query and useful details about them: data type, related field, operator.
NO
YES
Summary information about a query
Information about database objects and fields, output columns in the query is instantly available for the entire query, and for each sub-query and SQL expression.
NO
YES
Miscellaneous options
Localization of the user interface
Possibility to translate the interface of Active Query Builder into any language. Dozens of localizations available out-of-the-box.
YES
YES
Database server autodetection
Possibility to detect the SQL Syntax dialect upon connecting to a database server.
NO
YES

Full feature list of Active Query Builder ActiveX Edition

Feature FreeStand.
Main features
Visual SQL query builder
A user interface for designing the most complex SQL queries. Most operations are performed with a few mouse clicks or using drag-and-drop.
YES
YES
SQL query parser
Parsing of the most complex SELECT statements, building their object model for further analysis and modification.
YES
YES
SQL query reverse engeneering
Building a diagram of parsed SQL queries for visual representation of complex SQL query structures.
YES
YES
Two-way SQL query building
Instant switching between visual query building and direct SQL text editing at any time.
YES
YES
Customizable SQL text formatter
Plenty of settings to tune the formatting of your queries to your taste.
YES
YES
Full support of dozens of SQL dialects
The free version only supports basic SQL syntax constructs defined in the ANSI SQL standards. The paid versions support all the peculiarities of each SQL dialect. See the list of supported dialects.
No **
YES
Programming creation, analysis and editing of SQL queries
A full-featured API lets you create complex SQL queries from scratch, analyze and modify any part of your queries.
NO
YES
Visual Interface
Easy navigation across complex query structures
Visual representation and editing of the SQL query structure with unions, sub-queries, derived tables and Common Table Expressions (WITH clause).
YES
YES
Visual building of every single part of a SELECT query
Visual setting of grouping, ordering and filtering options for query columns and custom SQL expressions.
YES
YES
Quick search for database objects
Search and filtering by objects in the Database Schema Tree.
YES
YES
Automatic joining of tables in a query
Objects in a query are joined automatically according to the information about the database schema (foreign keys).
YES
YES
Manual creation of links between objects in a query
Joins between objects can be created by dragging-and-dropping fields from one object on the Design Pane to another.
YES
YES
Visual setting of specific properties of various query elements
Easy definition of data source aliases, join types, and various query properties, such as TOP/LIMIT, DISTINCT, etc.
NO
YES
Creating a user-friendly query building environment
Convenient names for database objects and fields
User-friendly names can be used during the visual query building process, as well as for direct SQL text editing. Their substitution for real names is performed invisibly for the end-user.
NO
YES
Virtual objects
Adding new objects to the database schema that appear identical to ordinary objects to the user in a visual and text query representation, and that turn into derived tables when the query is executed.
NO
YES
Calculated fields
Adding new fields to the list of database object fields that have no difference from ordinary fields to the user, which turn into SQL expressions or correlated sub-queries when the query is executed.
NO
YES
Saving the query diagram layout between work sessions
User can continue its job exactly where he/she has stopped. Sizes and positions of objects on the query diagram will be kept untouched.
NO
YES
Editing of sub-query text separately from the whole query
The text of any single sub-query can be accessed and changed separately from the whole query. Special events allow for interrupting visual changes to correct or cancel incorrect changes of sub-query text.
NO
YES
Database Schema handling
Automatic Database Schema extraction
Automatic extraction of the Database Schema is performed partially and on demand, taking into account the peculiarities of their representation for the given database server.
YES
YES
Metadata pre-filtering, hiding of unwanted objects
Partial metadata loading using filters to speed up initialization; programmatic hiding of unwanted objects from the user.
NO
YES
Programmatic filling of the metadata container
Objects can be added programmatically in case of a non-standard connection to the database (three-tier architecture, web service, etc.)
NO
YES
Saving and loading of metadata into the XML format
Loaded metadata can be cached to XML format to speed-up further metadata loading or to decrease the database server load.
NO
YES
Working without a live database connection
No live database connection is required in case of loading metadata from XML. It's possible to work with limited functionality without loading metadata.
NO
YES
Application Programming Interface
API for making additional changes to ready SQL queries
A handy API for applying additional filters, sorting, pagination to a query and retrieving totals to allow for a feature-rich user interface while browsing the query result.
NO
YES
Prevention of the execution of queries with unwanted objects
Checking a query for forbidden objects before its execution is possible without loading its visual representation and even without loading the database schema.
NO
YES
Information about the parameters found in a query
Retrieval of the list of parameters found in a query and useful details about them: data type, related field, operator.
NO
YES
Summary information about a query
Information about database objects and fields, output columns in the query is instantly available for the entire query, and for each sub-query and SQL expression.
NO
YES
Miscellaneous options
Localization of the user interface
Possibility to translate the interface of Active Query Builder into any language. Dozens of localizations available out-of-the-box.
YES
YES
Database server autodetection
Possibility to detect the SQL Syntax dialect upon connecting to a database server.
NO
YES

Notes

* The Core .NET version includes only the non-visual API of the component. Thus it lacks all features of the visual user interface.

** The Free version has support only for the most common features of SQL language up to ANSI SQL/92 standard while the paid versions support the great majority of database server-specific SQL syntax extensions for dozens of popular database servers.