Delphi SQL parser

Write or preferably enhance existing code to parse Oracle OR SqlServer SQL SELECT statements.

The goals are:

1) Parse out the selected "fields" in such a way that they can be used in populating a filter. This would also mean excluding constants from field list since filtering on COL4 if it is in select as 'ABC' as COL4 makes no sense. However, COL1 + ', ' + COL2 as CO4 would be valid.

2) Determine where in selected statement the filter is to go.

3) Locate where supplied parameters are to go (typically in where clauses) AND COL1 = :MyArg

Note the routine must be able to correctly parse very complex SQL containing functions, sub selects, unions, etc.

Thus, if ...,COL1,CASE WHEN [url removed, login to view] IS NOT NULL THEN FUNC1([url removed, login to view]) ELSE '' END AS COL2, ...

is part of select then filter would have label like "Col2" and if user specified Col2 should contain '12' the filter may look like

... AND (CASE WHEN [url removed, login to view] IS NOT NULL THEN FUNC1([url removed, login to view]) LIKE %12%) AND ...

and need to be placed in proper spot in a select that may or may not have a WHERE clause or may have several where clauses that are part of sub-selects, etc.

We have existing code that does a of this reasonably well, but still has issues. That could be used as starting point or some other existing open source or proprietary code could be suggested provided the licensing does no require releasing our code that makes used of it (GPL, etc.) Ideal solution would be a rules based lex type parser. GPL code can be considered if author is willing to grant us an alternate licence (perhaps for a fee) that is is more acceptable to us. We would need the source and would prefer it be in Delphi and be currently supported by author. If a fee to use code is required, we would have to agree to it, but would be willing to pay the fee.

You will be interfacing with another Delphi developer. We just have too many projects to focus on on this now and thought it would be a good thing to outsource.

General SQL Parser VCL version may be a good starting point or something based on a grammar like http://www.felix-colibri.com/papers/db/sql_parser/sql_parser.html. (However, I've had trouble reaching felix recently to work out licensing issues.)

Habilidades: Delphi

Ver más: sql parser delphi, sql open source projects, sql developer outsource, sql developer open source projects, sql developer open source, sql code oracle, outsource solution, oracle sql projects, oracle functions sql, Oracle Developer projects, open source sql, licensing solution, delphi projects open source, delphi for developer, delphi developer outsource, code developer outsource, by author, oracle sql with, write a grant, outsource oracle, oracle outsource, sql projects, oracle projects, Delphi developer, delphi filter

Información del empleador:
( 8 comentarios ) United States

Nº del proyecto: #6533048

14 freelancers están ofertando el promedio de $552 para este trabajo


Hello, I am happy to create such a parser for you. I have been working with Delphi for more then 10 years...I also familiar with complex queries in Oracle, I am writing them too...

$555 USD en 10 días
(10 comentarios)

Dear friend , I have experience with delphi please reference programs that I done use delphi: [login to view URL] Look forward to working with you!! Best Regards Duc

$555 USD en 20 días
(15 comentarios)

Aucune proposition n'a encore été fournie.

$388 USD en 5 días
(4 comentarios)

Hello sir, i am new at freelancer, i have experienced in Delphi programming since 1997, using many version of Delphi since Delphi 6 until Delphi XE3. has been experienced in Database Programming using MySQL, Inte Más

$400 USD en 7 días
(1 comentario)

I have 4+ years of experience in Delphi as well as in PL/SQL. I am working in a CMMI level 3 company in NCR India. I have worked on many support and enhancement projects in healthcare and retail domain. I have experien Más

$722 USD en 15 días
(0 comentarios)

A Fast development with the best Delphi programmer in freelancer.com Best Regards Fabricio Taguatinga

$555 USD en 3 días
(0 comentarios)

Hi, I am a full-time freelancer with over 13 years experience in web, desktop and mobile app developing. I have developed a lot of websites, desktop apps and mobiles apps and I have wonderful experience in freelancer's Más

$736 USD en 10 días
(0 comentarios)

I'm quite experienced with Delphi and wrote tons of parsers in my career, including a small script language which is used to configure a map database test system (write algorithms to count amount of features that has t Más

$444 USD en 10 días
(0 comentarios)

Good day. I am a programmer from Europe, Romania and I am willingly to take a shot at your parser if you trust my abilities. The way I will proceed is the following. Let's take an example: SELECT [login to view URL], [login to view URL] Más

$250 USD en 20 días
(0 comentarios)

hi. would be glad to help you with this great project. regards, yuri .

$555 USD en 45 días
(0 comentarios)

Még nem kapott javaslatot

$555 USD en 7 días
(0 comentarios)

you need SQL Builder in can do it for you , i have 9 years experience in delphi and such like applications , i make application like this for mysql database to help web programmer to generate code from database . T Más

$555 USD en 10 días
(0 comentarios)

Hi, I am actually an employer on Freelancer. I joined to hire some php programmers and graphic artist for my Adirondack Bucket List website. However, I am also a Delphi Developer - have been since 1995. I just saw your Más

$500 USD en 7 días
(0 comentarios)

A proposal has not yet been provided

$736 USD en 12 días
(0 comentarios)

I have worked already SQL Parser. I have full source code of parser having all possibale conditions e.g like, where, between, select etc. I can provide you working source code for that. I am a Delphi developer From Más

$722 USD en 15 días
(0 comentarios)