Hello Palla,
Thank you for your interest to our product and for your questions.
Can you please tell me what is the difference between your product and other products?
First of all, we did not find any other products with similar functionality for Java. There are some query builders to build simple SQL queries programmatically, there are some implementations of visual query building functionality, but they aren't present as Java beans. Please correct me if I mistaken.
Our component allows visual building of complex SQL queries (with unions, sub-queries, derived tables and many fine points of different SQL dialects) for most of today popular database servers, including Oracle, DB2, MySQL, etc. Also Active Query Builder has fast and sophisticated SQL parser, so it's normal practice to combine visual query building with direct SQL text editing. Of course, the component can be used to analyze, modify or create SQL queries programmatically from scratch.
Also how fast and easy can SQL developers adopt this product?
The
Quick Start Guide for Active Query Builder consists of several simple steps, so I hope there shouldn't be any problems with that. We provided various demo projects to illustrate all other aspects of Active Query Builder's functionality.
Can we develop PL/SQL queries on this?
The component has full support of Oracle SQL syntax. However,
you should note that the component is capable to build only single SELECT statements, so if you need to develop an SQL script builder, you'll have to implement some additional steps to extract single SELECT statements and pass them to the visual query builder and back.
How to use this product with common databases like Oracle, DB2, MySQL etc
Active Query Builder has a syntax provider for each supported database server, so the component will generate server-specific queries depending on the syntax provider being used.
Should you have any other questions, please do not hesitate to ask.