Automatic SQL query builder

From: Jaroslaw Tomczak <Jaroslaw.Tomczak_at_CCC.Chemie.Uni-Erlangen.DE>
Date: Wed, 10 Oct 2001 16:08:30 +0200
Message-ID: <3BC4565E.E87B2138@CCC.Chemie.Uni-Erlangen.DE>

Hi,

As a part o bigger project I develop a kind of automatic query builder. This application receives as input:
1. A list of search criteria -- field names, their locations within

appropriate tables and desired values

2. A list of fields that should be returned by query
3. Fields used for sorting results
4. Description of tables' relationships.

As the results the application returns a correctly formulated SQL query.

In trivial cases it is quite easy to analyse the above input and build appropriate queries, but many problems arises when one tries to implement joins and subqueries.

I'm simply looking for some papers, reports, links that would relate to the problem described above.

Thank you in advance,

--
;; Jaroslaw Tomczak
(let ((Computer-Chemie-Centrum 'http://www2.ccc.uni-erlangen.de))
     (visit Computer-Chemie-Centrum))

Received on Wed Oct 10 2001 - 09:08:30 CDT