search

sqlparser / gsp_demo

General SQL Parser is a Java/.NET library. It provides a rich set of APIs to parse, decode, analyze and rewrite SQL scripts. Supports more than 10 major database platforms. This repo provides demos and testcases to help people make better use of the General SQL Parser
http://www.sqlparser.com
23 stars 12 forks source link

Enhancement - SQLFlow JSON Output: Request to add functions used in calculations like count, sum. #6

Open fprima opened 5 years ago

fprima commented 5 years ago

It is important from a lineage perspective to have this information. For someone looking at the lineage diagram would like to know that an output column is a count of entries of the table, while another one is a Sum of an input column.

sqlparser commented 5 years ago

support in SQLFlow with backend v1.4.2

https://gudusoft.com/sqlflow/#/

Please give it a try and let me know the result.

sqlparser commented 5 years ago

constant also supported in the JSON output

UPDATE TABLE_ONE SET COLUMN_A = 100
WHERE COLUMN_A =200;