simple-ddl-parser
simple-ddl-parser copied to clipboard
Simple DDL Parser to parse SQL (HQL, TSQL, AWS Redshift, BigQuery, Snowflake and other dialects) ddl files to json/python dict with full information about columns: types, defaults, primary keys, etc....
**Describe the bug** The following is not parsed: ``` CREATE TABLE pole.t_zuschauer ( id int4 GENERATED BY DEFAULT AS IDENTITY( INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE...
**Is your feature request related to a problem? Please describe.** Comments on Columns like the following are parsed, but into a list instead of a dict with column name as...
**Describe the bug** The following is not parsed. Seems that the "case" statement is not supported. ``` create table pole.t_spiel ( id varchar(10) not null constraint t_spiel_pk primary key, v_id...