Build queries and learn SQL at the same time with a free SQL query builder.
EQB allows users to extract important information such as customer data, sales and virtually any other types of records. The solution does not require any extensive knowledge of SQL syntax and the inner workings of the databases, but it is also very useful for those learning SQL syntax, since you will be able to view the correct SQL statement after being translated from your natural-language query. Various database types are supported including MySQL, MS SQL Server, MS Access and Oracle.
- It's pretty much the only component I know of that does the specific job of providing a query builder tool that can be left between user hands.
- When the model is correctly built, it might run quite well
Cons
- The model builder app provided with the component matches the very definition of "atrocious", with a prehistoric sense of ergonomy and absolutely no keyboard shortcut whatsoever. Even Ctrl + S won't save your work, which you might lose at any moment because the soft is totally unstable.
- You might consider editing the xml model file by yourself to escape the torture of using the model editor. But the possibility obviously never occured to the author, because that file is clearly not human friendly, with abbreviated tag and attribute names that hardly make any sense.
- The HTML output is... Well, just don't read it if you care a bit about your mental sanity. And just go with the default theme, you DON'T want to read or edit the css files either.
Summary
Use only if you absolutely need such a tool for your project. Otherwise, run away and never look back.