TMS Query Studio v1.5.0.0 Full Source

Query Studio provides an easy way to give users access to powerful queries without requiring any knowledge about SQL. Users can setup complex queries in an almost natural language way with Query Studio. Dropping the component VisualQuery on the form and connect to the database opens the visual query power of Query Studio.

Feature details
Visual definition of SQL, in a natural language-like way
Localization support to easily translate all user interface elements
Allows definition of source tables and joins
Allows definition of order and filtering
Exclusive parameter editors feature: a value in the filter condition can be attached to a parameter editor. End-user can change editor value and it will automatically be reflected in SQL
Supports SQL syntax for Microsoft Access, Microsoft SQL Server, AnyDAC, Oracle, MySQL, Nexus, Interbase, DBISAM and Local BDE
Automatically set TDataset properties. Supports BDE, ADO, AnyDAC, IBX, DBISAM, Nexus, IBO, DirectSQL and DBExpress dataset descendants
Automatic grouping feature for aggregate functions usage
Support custom field expressions and custom filter conditions