SQL Query Builder
Full feature matrix
Full feature list of Active Query Builder WinForms and WPF Edition
| Feature | Free | Stand. | 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 |
|
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 SQL filter builder A visual user interface to add WHERE conditions to the columns of original SQL query. |
NO |
YES |
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 |
|
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 SQL filter builder A visual user interface to add WHERE conditions to the columns of original SQL query. |
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 | Free | 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 |
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 | Free | Stand. | Prof. |
|---|---|---|---|
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 |
|
SQL query parser Parsing of the most complex SELECT statements, building their object model for further analysis and modification. |
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 |
|
Two-way SQL query building Instant switching between visual query building and direct SQL text editing at any time. |
YES |
YES |
YES |
|
Customizable SQL text formatter Plenty of settings to tune the formatting of your queries to your taste. |
YES |
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 |
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 |
|
Advanced SQL text editor An SQL text editor with code completion and syntax highlighting. |
NO |
NO |
YES |
|
Visual SQL filter builder A visual user interface to add WHERE conditions to the columns of original SQL query. |
NO |
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 |
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 |
YES |
|
Quick search for database objects Search and filtering by objects in the Database Schema Tree. |
YES |
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 |
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 |
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 |
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 |
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 |
|
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 |
|
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 |
|
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 |
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 |
|
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 |
|
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 |
|
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 |
|
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 |
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 |
|
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 |
|
Programmatic SQL query analysis and modification Full access to the internal query object model for programmatic SQL query analysis and modification. |
NO |
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 |
|
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 |
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 |
|
Database server autodetection Possibility to detect the SQL Syntax dialect upon connecting to a database server. |
NO |
YES |
YES |
Full feature list of Active Query Builder ActiveX Edition
| Feature | Free | 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 |
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 |
News
- 04/03/2018
Active Query Builder ASP.NET Edition 3.2 lets build cross-domain apps and use it in a Docker container.
Demo projects for AngularJS, React, WebPack and Electron are included in the installation package. - 03/14/2018
Domain-specific language API to define SQL queries
Typesafe SQL construction and database object referencing through the generated database schema code. Are you interested? - 02/22/2018
All demo projects of Active Query Builder for .NET are available on GitHub now.
They do not require Active Query Builder installed, all dependencies get automatically updated from NuGet packages. Just clone a repository and run! - » Active Query Builder news
-
Subscribe
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.