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.)
14 freelancers are bidding on average $552 for this job
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...
Dear friend , I have experience with delphi please reference programs that I done use delphi: [url removed, login to view] Look forward to working with you!! Best Regards Duc
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 Daha Fazla
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 Daha Fazla
A Fast development with the best Delphi programmer in freelancer.com Best Regards Fabricio Taguatinga
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 Daha Fazla
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 Daha Fazla
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 [url removed, login to view], [url removed, login to view] Daha Fazla
hi. would be glad to help you with this great project. regards, yuri .
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla