Enhancement - SQLFlow JSON Output: For procedures, add information for Procedure Name and Input Parameters

[fprima]

Although this is not directly related to lineage, it will help us streamline our integration by having to look at one JSON output instead of looking at the JSON and XML.

[WillemLiang]

I have the same issue. It's really not convenient for visualizing XML with yWorks. Why not support JSON output? And also I notice that graph generation can auto placing elements. Is that possible add the graph generation in this feature?

[sqlparser]

@Liang3p Please take a look at SQLFlow here which can generate output in JSON and with a nice clean graph.

http://gudusoft.com/sqlflow

[sqlparser]

SQL Server stored procedure

CREATE PROCEDURE SelectAllCustomers @City nvarchar(30), @PostalCode nvarchar(10)
AS
SELECT * FROM Customers WHERE City = @City AND PostalCode = @PostalCode
GO;

[sqlparser]

@fprima implement the procedure and argument in the JSON output, please give it a try here:

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