0
votes

Hi All I am trying to Generate a DDL Code from json object I am getting from an API.

Input is like a definiton of table information such as; "Table name, columns name, data types of columns, relation types and relation to other table information."

And the output is a simple SQL query like

CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) );

Which path should I take at first?

Thanks.