Building T-SQL parser in Delphi

*(Changes were made on 05-Jun-03)* I need a Delphi programmer who has experience with "compiler compiler" tools, preferably Coco/R, to build a complete and accurate grammar for Transact-SQL. Understanding of SQL and relational databases is a plus. The chosen coder will be provided with a grammar file in Coco/R format already containing most Transact-SQL constructs. However, (a) the grammar contains a number of LL(1) violations, (b) it is not verified to be complete and (c) the generated parser is not integrated with an input stream class provided by TSyntaxMemo component used in my application. The coder must: * Make the grammar file compile without errors * Build an "adapter" class (or modify Coco/R base classes) to allow the generated parser to use the input stream provided by the SyntaxMemo component. * Check against MSSQL documentation to see if anything is missing and add the missing productions. In this project, the resulting parser need not do something very useful with the SQL code, just output some details of the parsing process (see "Deliverables" section). If everything goes well, there will be a follow-up project where you will have to build from the parsed CREATE/ALTER/DROP statements an internal model of the database schema. ## Deliverables 1) The deliverables shall include (a) the complete and accurate grammar definitions for Transact-SQL, (b) the working parser (source code) built from these definitions, basing on the provided testbed application. The parser must demonstrate the following: * Parse the text in the editor (or any selected part of it) using the developed "adapter" class; * Provide reasonable warnings on any syntax errors in the input text (SQL script); * Correctly determine where one statement ends and the next one begins (even when statement separators aren't there); * As an SQL is being parsed, output some status information about the statement. * For all CREATE, DROP, ALTER, GRANT/DENY/REVOKE statements as well as for stored procedure calls (like "exec sp_addtype ..."), extract and output all relevant information (column names, types, etc), keeping in mind that the next version of the parser will have to build a hierarchy of schema objects from this information. 2) Complete ownership and distribution copyrights to all work purchased. ## Platform Windows 98/NT/XP, Delphi 6