Sql Query Parser
Posted on 2003-11-17
first of all sorry for my English!
i want code for query parser wriiten in any higher level lang.
the thing is that code should support normal select ,where ,having and group by
and everything that is needed to write an query.
actually the thing is
fieldnames and tablenames, which user gives in input query, are different from those of actual database
so i want mapp the fieldnames and tablenames with some different names and then want to form a new query which database can execute and then want to give output in users format.
so plz guide me how to do this also if there is some query parser kind of thing with code then that can be also useful or else any other advice is most wel-come.
thanks in advance