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. & table properties, types, domains, etc.
MIT License
Bot releases are hidden (Show)
Published by xnuinside 5 months ago
unique
set up to column only if it was only one column in unique constraint/index. Issue - https://github.com/xnuinside/simple-ddl-parser/issues/255
Published by xnuinside 5 months ago
temp
& is_global
. Added support for create global temporary table - https://github.com/xnuinside/simple-ddl-parser/issues/182
Published by xnuinside 5 months ago
Published by xnuinside 5 months ago
Published by xnuinside 6 months ago
🐬 MySQL:
❄ Snowflake:
Published by xnuinside 7 months ago
DEFAULT
and CHECK
statements. https://github.com/xnuinside/simple-ddl-parser/issues/240
Published by xnuinside 9 months ago
v1.0.3
CREATE OR REPLACE SCHEMA
.stage_
fileformat option value equal a single string as FIELD_OPTIONALLY_ENCLOSED_BY = '\"'
, FIELD_DELIMITER = '|'
Published by xnuinside 9 months ago
Published by xnuinside 9 months ago
v1.0.1
normalize_names=True
do not remove []
from types like decimal(21)[]
.normalize_names=True
ensure that "complex"."type"
style names convert to complex.type
.Published by xnuinside 10 months ago
v1.0.0
In output structure was done important changes that can in theory breaks code.
all custom table properties that are defined after column definition in 'CREATE TABLE' statement and relative to only one dialect (only for SparkSQL, or HQL,etc), for example, like here:
https://github.com/xnuinside/simple-ddl-parser/blob/main/tests/dialects/test_snowflake.py#L767 or https://github.com/xnuinside/simple-ddl-parser/blob/main/tests/dialects/test_spark_sql.py#L133 will be saved now in property table_properties
as dict.
Previously they was placed on same level of table output as columns
, alter
, etc. Now, they grouped and moved to key table_properties
.
And more.
Full Changelog of version 1.0.0: https://github.com/xnuinside/simple-ddl-parser/blob/main/CHANGELOG.txt#L1
Published by xnuinside 10 months ago
v0.32.0
create table
statement and alter.Published by xnuinside 10 months ago
v0.31.3
AS ()
statement - https://github.com/xnuinside/simple-ddl-parser/issues/218
Big-big thanks for contribution goes to https://github.com/dmaresma and https://github.com/cfhowes
Published by xnuinside 10 months ago
v0.31.2
ORDER|NOORDER
statement - https://github.com/xnuinside/simple-ddl-parser/issues/213
Thanks to https://github.com/dmaresma for contributions.
Published by xnuinside 12 months ago
WITH TAG
statement.Published by xnuinside about 1 year ago
v0.31.0
Snowflake Table DDL support of WITH MASKING POLICY column definition
- https://github.com/xnuinside/simple-ddl-parser/issues/201
Published by xnuinside over 1 year ago
IN TABLESPACE IBM DB2 statement now is parsed into 'tablespace' key. Issue: https://github.com/xnuinside/simple-ddl-parser/issues/194.
INDEX IN also parsed to 'index_in' key.
Added support for ORGANIZE BY statement
Added support for PostgreSQL INHERITS statement. Issue: https://github.com/xnuinside/simple-ddl-parser/issues/191
Published by xnuinside almost 2 years ago
v0.29.0
Published by xnuinside almost 2 years ago
v0.28.1
Published by xnuinside almost 2 years ago
v0.28.0
MariaDB:
/* */
syntax.group_by_type=
arg in parser.Published by xnuinside about 2 years ago
v0.27.0
Fixes:
Improvements:
New features: