Whether it's embedded into a database administration tool or a user report generator, in a Windows application or web page, the Active SQL Query Builder component is your best solution for almost any software. Its user-friendly interface and unique query parsing and research capabilities provide optimized results and is sure to increase the number of potential users of your product.
The Active Query Builder component suite is a perfect choice for both SQL beginners and experienced query writers. It renders all SQL features, such as sub-queries and unions, very easy to accomplish and provides the professional user with everything he or she needs to efficiently work with SQL queries. There are wide opportunities to customize the presentation of database schema for the end-user in order ensure an easy understanding of the database structure.
Active Query Builder can be an unfailing assistant in parsing, analyzing and modifying SQL queries. It provides full control over the user SQL queries: you can get detailed information about every part of the query. You'll be able to deny the execution of unwanted queries or seamlessy change them prior to execution from the end-user. User queries are no longer a black box; they are an open book!
Active Query Builder can help to increase the range of potential users of their product, improve its usability, and speed up the software development process. By embedding Active Query Builder into your product, you can make it easy for beginners and provide a powerful tool for professionals.
Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.
Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.
Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.