Parse SQL Queries - Extract Join Criteria
Budget: $30 – $250 USD
Sql Query Parse Join Columns.
I need a way to parse sql queries and build a list of table.schema.columns used in the join criteria.
1-Needs to be able to paste text (queries) in a textbox or load from a file. They can be many stacked in one file.
2-It needs to extract the join criteria from the queries.
3-It needs to format in a tab delimited file.
+Tabe delimited.
+Schema and table name written out (not alias) and combined.
4-If there are more than 1 criteria between 2 tables (meaning joining on more than 1 column), they both need to be listed and have a unique group number associated (that does not exist in the output file).
5-The output file can not have duplicates across all columns.
It needs to be written in VB.NET 4.7+ Winforms Application.
You can use sqlparser.com library (they have trial) to do the parsing if needed.
It needs to be extremely accurate and smooth with good code.
Attached is an example and output format.
Max bid: 30
When submit bid, please answer: what day of the week is it? (to filter out fake bot bids!)
I need a way to parse sql queries and build a list of table.schema.columns used in the join criteria.
1-Needs to be able to paste text (queries) in a textbox or load from a file. They can be many stacked in one file.
2-It needs to extract the join criteria from the queries.
3-It needs to format in a tab delimited file.
+Tabe delimited.
+Schema and table name written out (not alias) and combined.
4-If there are more than 1 criteria between 2 tables (meaning joining on more than 1 column), they both need to be listed and have a unique group number associated (that does not exist in the output file).
5-The output file can not have duplicates across all columns.
It needs to be written in VB.NET 4.7+ Winforms Application.
You can use sqlparser.com library (they have trial) to do the parsing if needed.
It needs to be extremely accurate and smooth with good code.
Attached is an example and output format.
Max bid: 30
When submit bid, please answer: what day of the week is it? (to filter out fake bot bids!)