SQL Query builder in Delphi

Question

I need to give users the ability to build a simple SQL query against our database. Our application is written in Delphi.

I am assuming only moderate levels of knowledge by the user, but they need the ability to build a simple select statement to be able to query against a couple of tables. If I can make this easy for them, that would be most wondrous.

Does anyone know of a tool or a set of components that I can use to help the users build SQL SELECT statements...

Answer 1

I've used the DevExpress ExpressFilter control to allow users to specify SQL where constraints before.

Answer 2

I've come across FastQueryBuilder http://fast-report.com/en/products/visual-query-builder.html and OpenQueryBuilder http://fast-report.com/en/products/free-query-builder.html (apparently differing versions of the same tool) at Fast-Report. It looks like the right idea. Anyone have any experience with it?