Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!newspeer.monmouth.com!uni-erlangen.de!news.uni-erlangen.de!not-for-mail
From: Jaroslaw Tomczak <Jaroslaw.Tomczak@CCC.Chemie.Uni-Erlangen.DE>
Newsgroups: comp.databases.theory,comp.databases
Subject: Automatic SQL query builder
Date: Wed, 10 Oct 2001 16:08:30 +0200
Organization: Computer-Chemie-Centrum
Lines: 24
Message-ID: <3BC4565E.E87B2138@CCC.Chemie.Uni-Erlangen.DE>
NNTP-Posting-Host: helium.chemie.uni-erlangen.de
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: rznews2.rrze.uni-erlangen.de 1002722910 10425 131.188.127.154 (10 Oct 2001 14:08:30 GMT)
X-Complaints-To: news@uni-erlangen.de
NNTP-Posting-Date: 10 Oct 2001 14:08:30 GMT
X-Mailer: Mozilla 4.78 [en] (X11; U; OSF1 V4.0 alpha)
X-Accept-Language: en
Xref: easynews comp.databases.theory:18637 comp.databases:89990
X-Received-Date: Wed, 10 Oct 2001 07:51:58 MST (news.easynews.com)

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))