SQL Query Builder
Full Feature List
Full feature list of Active Query Builder WinForms and WPF Edition for desktop GUI apps and non-visual use
| Feature | Stand. | Prof. | Non-vis. |
|---|---|---|---|
Main features |
|||
|
Visual SQL query builder Visual designer for building SELECT statements with simple drag'n'drop and point'n'click actions. |
YES |
YES |
NO |
|
SQL query parser Parsing of SELECT statements of any complexity, building SQL query object model for further analysis and modification. |
YES |
YES |
YES |
|
SQL query reverse engineering Building diagrams of parsed queries for their review and further editing. |
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 |
N/A * |
|
Customizable SQL text formatting Plenty of settings to tune the formatting of your queries to your taste. |
YES |
YES |
YES |
|
Support of dozens of SQL dialects The free version only supports basic SQL syntax constructs defined in the ANSI SQL standards. The paid version supports all the peculiarities of each SQL dialect. See the list of supported dialects. |
YES |
YES |
YES |
|
Programming creation, analysis and editing of SQL queries A full-featured API to create complex SQL queries from scratch, analyse and modify SQL queries. |
YES |
YES |
YES |
|
Visual SQL Filter Builder A visual control to add conditions for the columns of original SQL query appending them to the WHERE clause. |
YES |
YES |
N/A * |
|
Professional SQL Text Editor Feature-rich SQL text editor with code completion and syntax highlighting. |
NO |
YES |
N/A * |
SQL Query Designer features |
|||
|
Easy navigation across complex query structures Representing complex SQL queries with unions, sub-queries, derived tables and Common Table Expressions (WITH clause) visually. |
YES |
YES |
N/A * |
|
Visual interface to work with each single part of a SELECT statement Select query columns from the fields of database objects, and by using SQL expressions. Building of grouping, sorting and filtration with point-and-click actions. |
YES |
YES |
N/A * |
|
Quick search for database objects Search and filtration by objects in the Database Schema View. |
YES |
YES |
N/A * |
|
Automatic joining of tables by foreign keys Creation of joins with correct join expressions automatically according to the information retrieved from the database schema. |
YES |
YES |
N/A * |
|
Manual creation of links between objects in a query Defining joins between query objects on the query diagram by drag'n'drop. Manual editing of the join type and expression. |
YES |
YES |
N/A * |
|
Joining tables which are indirectly linked with each other Automatic addition of intermediate tables to the query upon adding a new table to maintain coherence with existing tables. |
YES |
YES |
N/A * |
|
Setting of TOP, LIMIT, DISTINCT and other query options Properties of sub-queries, query objects and joins can be defined visually. |
YES |
YES |
N/A * |
|
SQL Expression Editor Handy dialog to edit complex SQL expressions via the multiline text editor with code completion, syntax highlighting and the lookup lists of objects, fields and SQL functions. |
NO |
YES |
N/A * |
Query building environment customization options |
|||
|
Convenient names for database objects and fields User-friendly aliases can be displayed instead of the unintelligible database object and field names in the visual query designer an in the SQL query text. Their substitution for real names is performed seamlessly for the end-user. |
YES |
YES |
YES |
|
Virtual objects Creation of non-existing objects for use the same way as regular database objects in the designer and query text, |
YES |
YES |
YES |
|
Calculated fields Definition of non-exising fields for use the same way as regular fields in the designer and query text |
YES |
YES |
YES |
|
Reimagining the database schema tree view Arbitrary grouping of database objects within the tree according to subject areas. |
YES |
YES |
N/A * |
|
Saving the query diagram layout between work sessions The user can continue its job exactly where he/she has stopped. Sizes and positions of objects on the query diagram will preserved. |
YES |
YES |
N/A * |
|
Editing of sub-query text separately from the entire query The text of any single sub-query can be accessed and changed independently of the main query. |
YES |
YES |
N/A * |
|
Decomposable visual user interface Possibility to decompose and customize the user interface by removing, reorganising and adding new visual controls. |
NO |
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 |
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 |
|
Metadata pre-filtering, hiding unwanted objects Partial metadata loading using filters to speed up initialisation; programmatic hiding unwanted objects from the user. |
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.) |
YES |
YES |
YES |
|
Saving and loading of metadata into the XML format Caching the loaded metadata to XML format speeds up further metadata loading or to decrease the database server load. |
YES |
YES |
YES |
|
Working without a live database connection No need to establish the live database connection and overload the database server in the case of loading metadata from XML. It's also possible to work without loading metadata. |
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. |
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. |
YES |
YES |
YES |
|
Programmatic SQL query analysis and modification Full access to the internal query object model for programmatic SQL query analysis and modification. |
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. |
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. |
YES |
YES |
YES |
Miscellaneous options |
|||
|
Localization of the user interface Possibility to translate the interface of Active Query Builder into any language. Dozens of localisations available out-of-the-box. |
YES |
YES |
N/A * |
|
Database server autodetection Possibility to detect the SQL Syntax dialect upon connecting to a database server. |
YES |
YES |
YES |
Full feature list of Active Query Builder ASP.NET Edition for WebForms, MVC, and ASP.NET Core
| Feature | Stand. | Prof. | Corp. |
|---|---|---|---|
ASP.NET-specific features |
|||
|
Multiple queries per user session Simultaneous building of different queries in separate browser windows or designing more than one query on a web page. |
NO |
YES |
YES |
|
Storing client state without using ASP.NET session Unlimited possibilities for configuring the application architecture: containerization, usage in web farms, cross-domain or stateless systems. |
NO |
NO |
YES |
Main features |
|||
|
Visual SQL query builder Visual designer for building SELECT statements with simple drag'n'drop and point'n'click actions. |
YES |
YES |
YES |
|
SQL query parser Parsing of SELECT statements of any complexity, building SQL query object model for further analysis and modification. |
YES |
YES |
YES |
|
SQL query reverse engineering Building diagrams of parsed queries for their review and further editing. |
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 formatting Plenty of settings to tune the formatting of your queries to your taste. |
YES |
YES |
YES |
|
Support of dozens of SQL dialects The free version only supports basic SQL syntax constructs defined in the ANSI SQL standards. The paid version supports all the peculiarities of each SQL dialect. See the list of supported dialects. |
YES |
YES |
YES |
|
Programming creation, analysis and editing of SQL queries A full-featured API to create complex SQL queries from scratch, analyse and modify SQL queries. |
YES |
YES |
YES |
|
Visual SQL Filter Builder A visual control to add conditions for the columns of original SQL query appending them to the WHERE clause. |
YES |
YES |
YES |
SQL Query Designer features |
|||
|
Easy navigation across complex query structures Representing complex SQL queries with unions, sub-queries, derived tables and Common Table Expressions (WITH clause) visually. |
YES |
YES |
YES |
|
Visual interface to work with each single part of a SELECT statement Select query columns from the fields of database objects, and by using SQL expressions. Building of grouping, sorting and filtration with point-and-click actions. |
YES |
YES |
YES |
|
Quick search for database objects Search and filtration by objects in the Database Schema View. |
YES |
YES |
YES |
|
Automatic joining of tables by foreign keys Creation of joins with correct join expressions automatically according to the information retrieved from the database schema. |
YES |
YES |
YES |
|
Manual creation of links between objects in a query Defining joins between query objects on the query diagram by drag'n'drop. Manual editing of the join type and expression. |
YES |
YES |
YES |
|
Joining tables which are indirectly linked with each other Automatic addition of intermediate tables to the query upon adding a new table to maintain coherence with existing tables. |
YES |
YES |
YES |
|
Setting of TOP, LIMIT, DISTINCT and other query options Properties of sub-queries, query objects and joins can be defined visually. |
YES |
YES |
YES |
Query building environment customization options |
|||
|
Convenient names for database objects and fields User-friendly aliases can be displayed instead of the unintelligible database object and field names in the visual query designer an in the SQL query text. Their substitution for real names is performed seamlessly for the end-user. |
YES |
YES |
YES |
|
Virtual objects Creation of non-existing objects for use the same way as regular database objects in the designer and query text, |
YES |
YES |
YES |
|
Calculated fields Definition of non-exising fields for use the same way as regular fields in the designer and query text |
YES |
YES |
YES |
|
Reimagining the database schema tree view Arbitrary grouping of database objects within the tree according to subject areas. |
YES |
YES |
YES |
|
Saving the query diagram layout between work sessions The user can continue its job exactly where he/she has stopped. Sizes and positions of objects on the query diagram will preserved. |
YES |
YES |
YES |
|
Editing of sub-query text separately from the entire query The text of any single sub-query can be accessed and changed independently of the main query. |
NO |
YES |
YES |
|
Decomposable visual user interface Possibility to decompose and customize the user interface by removing, reorganising and adding new visual controls. |
YES |
YES |
YES |
|
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 |
YES |
YES |
|
Addition of calcluated fields by user Advanced users can add new calcluated fields to the database object fields list. |
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 unwanted objects Partial metadata loading using filters to speed up initialisation; programmatic hiding unwanted objects from the user. |
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.) |
YES |
YES |
YES |
|
Saving and loading of metadata into the XML format Caching the loaded metadata to XML format speeds up further metadata loading or to decrease the database server load. |
YES |
YES |
YES |
|
Working without a live database connection No need to establish the live database connection and overload the database server in the case of loading metadata from XML. It's also possible to work without loading metadata. |
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. |
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. |
YES |
YES |
YES |
|
Programmatic SQL query analysis and modification Full access to the internal query object model for programmatic SQL query analysis and modification. |
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. |
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. |
YES |
YES |
YES |
Miscellaneous options |
|||
|
Localization of the user interface Possibility to translate the interface of Active Query Builder into any language. Dozens of localisations available out-of-the-box. |
YES |
YES |
YES |
|
Database server autodetection Possibility to detect the SQL Syntax dialect upon connecting to a database server. |
YES |
YES |
YES |
Full feature list of Active Query Builder Java Edition for Swing GUI Tooklit
| Feature | Stand. |
|---|---|
Main features |
|
|
Visual SQL query builder Visual designer for building SELECT statements with simple drag'n'drop and point'n'click actions. |
YES |
|
SQL query parser Parsing of SELECT statements of any complexity, building SQL query object model for further analysis and modification. |
YES |
|
SQL query reverse engineering Building diagrams of parsed queries for their review and further editing. |
YES |
|
Two-way SQL query building Instant switching between visual query building and direct SQL text editing at any time. |
YES |
|
Customizable SQL text formatting Plenty of settings to tune the formatting of your queries to your taste. |
YES |
|
Support of dozens of SQL dialects The free version only supports basic SQL syntax constructs defined in the ANSI SQL standards. The paid version supports 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 to create complex SQL queries from scratch, analyse and modify SQL queries. |
YES |
SQL Query Designer features |
|
|
Easy navigation across complex query structures Representing complex SQL queries with unions, sub-queries, derived tables and Common Table Expressions (WITH clause) visually. |
YES |
|
Visual interface to work with each single part of a SELECT statement Select query columns from the fields of database objects, and by using SQL expressions. Building of grouping, sorting and filtration with point-and-click actions. |
YES |
|
Quick search for database objects Search and filtration by objects in the Database Schema View. |
YES |
|
Automatic joining of tables by foreign keys Creation of joins with correct join expressions automatically according to the information retrieved from the database schema. |
YES |
|
Manual creation of links between objects in a query Defining joins between query objects on the query diagram by drag'n'drop. Manual editing of the join type and expression. |
YES |
|
Setting of TOP, LIMIT, DISTINCT and other query options Properties of sub-queries, query objects and joins can be defined visually. |
YES |
Query building environment customization options |
|
|
Convenient names for database objects and fields User-friendly aliases can be displayed instead of the unintelligible database object and field names in the visual query designer an in the SQL query text. Their substitution for real names is performed seamlessly for the end-user. |
YES |
|
Virtual objects Creation of non-existing objects for use the same way as regular database objects in the designer and query text, |
YES |
|
Calculated fields Definition of non-exising fields for use the same way as regular fields in the designer and query text |
YES |
|
Saving the query diagram layout between work sessions The user can continue its job exactly where he/she has stopped. Sizes and positions of objects on the query diagram will preserved. |
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 unwanted objects Partial metadata loading using filters to speed up initialisation; programmatic hiding 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 Caching the loaded metadata to XML format speeds up further metadata loading or to decrease the database server load. |
YES |
|
Working without a live database connection No need to establish the live database connection and overload the database server in the case of loading metadata from XML. It's also possible to work 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 localisations 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 VCL Edition for Embarcadero Delphi and C++Builder
| Feature | Stand. | Prof. |
|---|---|---|
Main features |
||
|
Visual SQL query builder Visual designer for building SELECT statements with simple drag'n'drop and point'n'click actions. |
YES |
YES |
|
SQL query parser Parsing of SELECT statements of any complexity, building SQL query object model for further analysis and modification. |
YES |
YES |
|
SQL query reverse engineering Building diagrams of parsed queries for their review and further editing. |
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 formatting Plenty of settings to tune the formatting of your queries to your taste. |
YES |
YES |
|
Support of dozens of SQL dialects The free version only supports basic SQL syntax constructs defined in the ANSI SQL standards. The paid version supports all the peculiarities of each SQL dialect. See the list of supported dialects. |
YES |
YES |
|
Programming creation, analysis and editing of SQL queries A full-featured API to create complex SQL queries from scratch, analyse and modify SQL queries. |
YES |
YES |
|
Visual SQL Filter Builder A visual control to add conditions for the columns of original SQL query appending them to the WHERE clause. |
NO |
YES |
|
Professional SQL Text Editor Feature-rich SQL text editor with code completion and syntax highlighting. |
NO |
YES |
SQL Query Designer features |
||
|
Easy navigation across complex query structures Representing complex SQL queries with unions, sub-queries, derived tables and Common Table Expressions (WITH clause) visually. |
YES |
YES |
|
Visual interface to work with each single part of a SELECT statement Select query columns from the fields of database objects, and by using SQL expressions. Building of grouping, sorting and filtration with point-and-click actions. |
YES |
YES |
|
Quick search for database objects Search and filtration by objects in the Database Schema View. |
YES |
YES |
|
Automatic joining of tables by foreign keys Creation of joins with correct join expressions automatically according to the information retrieved from the database schema. |
YES |
YES |
|
Manual creation of links between objects in a query Defining joins between query objects on the query diagram by drag'n'drop. Manual editing of the join type and expression. |
YES |
YES |
|
Setting of TOP, LIMIT, DISTINCT and other query options Properties of sub-queries, query objects and joins can be defined visually. |
YES |
YES |
|
SQL Expression Editor Handy dialog to edit complex SQL expressions via the multiline text editor with code completion, syntax highlighting and the lookup lists of objects, fields and SQL functions. |
NO |
YES |
Query building environment customization options |
||
|
Convenient names for database objects and fields User-friendly aliases can be displayed instead of the unintelligible database object and field names in the visual query designer an in the SQL query text. Their substitution for real names is performed seamlessly for the end-user. |
YES |
YES |
|
Virtual objects Creation of non-existing objects for use the same way as regular database objects in the designer and query text, |
YES |
YES |
|
Calculated fields Definition of non-exising fields for use the same way as regular fields in the designer and query text |
YES |
YES |
|
Saving the query diagram layout between work sessions The user can continue its job exactly where he/she has stopped. Sizes and positions of objects on the query diagram will preserved. |
YES |
YES |
|
Editing of sub-query text separately from the entire query The text of any single sub-query can be accessed and changed independently of the main query. |
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 |
|
Metadata pre-filtering, hiding unwanted objects Partial metadata loading using filters to speed up initialisation; programmatic hiding unwanted objects from the user. |
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.) |
YES |
YES |
|
Saving and loading of metadata into the XML format Caching the loaded metadata to XML format speeds up further metadata loading or to decrease the database server load. |
YES |
YES |
|
Working without a live database connection No need to establish the live database connection and overload the database server in the case of loading metadata from XML. It's also possible to work without loading metadata. |
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. |
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. |
YES |
YES |
|
Programmatic SQL query analysis and modification Full access to the internal query object model for programmatic SQL query analysis and modification. |
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. |
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. |
YES |
YES |
Miscellaneous options |
||
|
Localization of the user interface Possibility to translate the interface of Active Query Builder into any language. Dozens of localisations available out-of-the-box. |
YES |
YES |
|
Database server autodetection Possibility to detect the SQL Syntax dialect upon connecting to a database server. |
YES |
YES |
Full feature list of Active Query Builder ActiveX Edition for any COM/ActiveX-enabled environments
| Feature | Stand. |
|---|---|
Main features |
|
|
Visual SQL query builder Visual designer for building SELECT statements with simple drag'n'drop and point'n'click actions. |
YES |
|
SQL query parser Parsing of SELECT statements of any complexity, building SQL query object model for further analysis and modification. |
YES |
|
SQL query reverse engineering Building diagrams of parsed queries for their review and further editing. |
YES |
|
Two-way SQL query building Instant switching between visual query building and direct SQL text editing at any time. |
YES |
|
Customizable SQL text formatting Plenty of settings to tune the formatting of your queries to your taste. |
YES |
|
Support of dozens of SQL dialects The free version only supports basic SQL syntax constructs defined in the ANSI SQL standards. The paid version supports 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 to create complex SQL queries from scratch, analyse and modify SQL queries. |
YES |
SQL Query Designer features |
|
|
Easy navigation across complex query structures Representing complex SQL queries with unions, sub-queries, derived tables and Common Table Expressions (WITH clause) visually. |
YES |
|
Visual interface to work with each single part of a SELECT statement Select query columns from the fields of database objects, and by using SQL expressions. Building of grouping, sorting and filtration with point-and-click actions. |
YES |
|
Quick search for database objects Search and filtration by objects in the Database Schema View. |
YES |
|
Automatic joining of tables by foreign keys Creation of joins with correct join expressions automatically according to the information retrieved from the database schema. |
YES |
|
Manual creation of links between objects in a query Defining joins between query objects on the query diagram by drag'n'drop. Manual editing of the join type and expression. |
YES |
|
Setting of TOP, LIMIT, DISTINCT and other query options Properties of sub-queries, query objects and joins can be defined visually. |
YES |
Query building environment customization options |
|
|
Convenient names for database objects and fields User-friendly aliases can be displayed instead of the unintelligible database object and field names in the visual query designer an in the SQL query text. Their substitution for real names is performed seamlessly for the end-user. |
YES |
|
Virtual objects Creation of non-existing objects for use the same way as regular database objects in the designer and query text, |
YES |
|
Calculated fields Definition of non-exising fields for use the same way as regular fields in the designer and query text |
YES |
|
Saving the query diagram layout between work sessions The user can continue its job exactly where he/she has stopped. Sizes and positions of objects on the query diagram will preserved. |
YES |
|
Editing of sub-query text separately from the entire query The text of any single sub-query can be accessed and changed independently of the main query. |
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 unwanted objects Partial metadata loading using filters to speed up initialisation; programmatic hiding 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 Caching the loaded metadata to XML format speeds up further metadata loading or to decrease the database server load. |
YES |
|
Working without a live database connection No need to establish the live database connection and overload the database server in the case of loading metadata from XML. It's also possible to work 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 |
|
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 localisations available out-of-the-box. |
YES |
|
Database server autodetection Possibility to detect the SQL Syntax dialect upon connecting to a database server. |
YES |
News
- 05/20/2021
Active Query Builder for .NET 3.8 (All editions) adds support for .NET 5.0 and makes visual query building a charm.
Narrowed Query Columns List, eased navigation over sub-queries, and tons of minor user and developer-side improvements. - 08/28/2020
Active Query Builder for .NET 3.7 brings support for .NET Core 3.1, new SQL syntaxes and further UI improvements.
Changes in query navigation bars let find the right subquery and pinpoint the location of the current subquery faster. Support for Snowflake DB and QuickBooks (QODBC) SQL syntaxes is added. - 04/22/2020
Active Query Builder ASP.NET Edition 3.6 helps find and change various options in the query faster.
With the new version, the user sees all the applied data manipulations right on the Design Pane and can change them in a few clicks. - » Active Query Builder news
-
Subscribe
Testimonials
We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!
We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...
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!
Joel Tesdall
Rating:
5 out of 5
Notes
* The Non-visual .NET version doesn't provide any visual user interfaces, it is only for the programmatic use of API.
** 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.