We don't see things as they are, we see things as we are. ComponentOne Query 1.0 lets developers add ad hoc querying to their applications quickly and easily and make it available to users immediately. ComponentOne has announced ComponentOne Query 1.0. ComponentOne Query gathers user input and generates an SQL query or an ADO Filter condition at runtime. Developers benefit because they don't have to think up all imaginable queries beforehand.
Users benefit because they're protected from the database structure complexities.
They can use user-friendly names and business concepts that they already know. You can even customize the resulting SQL syntax to meet your database requirements. The query generation engine lets you run queries across multiple tables, so you can create schemas to expose database fields to your users in a customized form by specifying relationships between tables. The built-in user interface eases development. To implement ad hoc querying, you just drop two controls on a form.