I need an application written in C or C++ that **parses any SQL SELECT** statement written conformant to the ANSI SQL standard and extracts a list of all tables and fields used in the query.
The list may be written to disk as a disk file.
The application must parse queries that contain joined tables, subqueries, and functions.
It is expected that the developer will use LEX/YACC, BISON or similar to assist in code generation.
The application must be delivered as source code, and must compile on Red Hat Linux (9) and under Microdsoft Visual C.
Test queries are available on request.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
3) Description of any known limitations
Linux, Windows NT