"(fld1+fld2>fld3 and ...) or ..." on several tables for ORACLE Forms/D2000/...

Hi everybody in the WORLD

        Can enybody advice me which tool/utility to choose to allow my users who are far from knowing SQL to feel comfortable with making queries. To describe the matter more carefully i'll give an example of the programm which has been satisfying us till today:

        C library (C,yacc,UNIX). It's a some kind of translator from "handmade" language(HML hereinafter) to "select ...". A user operates only with aliases of real fields and constants. The programm uses InitFile to load declarations of fiels (realname,alias,type), tables, and table relations, dateformat etc. It supports all searchable ORACLE types (number,varchar2/char,date,null) for "+-/*(),like,in,between,and,or,not,union,intersect,minus,><=<>, is null,||". It allows user to do something like below:

HML "name=SOCOBORO and bdate='01/01/12'|'01/01/35'..."

SQL	(select ... where t1.name='SOCOBORO' and t1.birthday between
	to_date('...','FMT') and to_date('...','FMT')...)

SQL	(select .... from t1,t2,t3 where t1.key=t2.key .....
	and ( 
	(t1.f1>(t2.date1-t2.date2-30) or t3.fa is not null) and
	to_char(t1.date3,'FMT') like '12/__/97')
	    )
	UNION
	select ......)

Joining tables programm finds the shortest way in a tree. Autoconvertation of types makes possible to do HML "datefiels||'ABC'||numberfield='%12345%'" SQL (to_char(datefield,'FMT')||'ABC'||to_char(numberfield) like '%12345%')

The question is: is there any standard product with possibility to provide wide opportunity of a search and to be linked with ORACLE tools as a user_exit or joined in another way? I'm involved in the number of tools appearancing day in day out.

By the way, if you don't know a tool I asked above but need one, get in touch with me. At least I'll send my version. Free of charge.

-- 
Eduard A. Godlevsky
ouvd_at_tetragr.zaporizhzhe.ua