{"repo":"xnuinside/simple-ddl-parser","free":true,"listed":false,"github":"https://github.com/xnuinside/simple-ddl-parser","clone":"git clone https://github.com/xnuinside/simple-ddl-parser.git","description":"Lightweight SQL DDL parser for extracting tables, columns, and schema metadata with broad multi-dialect support (HQL, TSQL, AWS Redshift, BigQuery, Snowflake and other dialects)","language":"Python","stars":222,"topics":["sql","ddl","parser","ddl-parser","sql-parser","postgresql","hive","mysql","schemas","tsql"],"license":"MIT","category":"databases-storage","readme_excerpt":"Simple DDL Parser Build with ply (lex & yacc in python). A lot of samples in 'tests/. Is it Stable? Yes, library already has about 9000+ downloads per day - https://pypistats.org/packages/simple-ddl-parser.. As maintainer, I guarantee that any backward incompatible changes will not be done in patch or minor version. But! Pay attention that sometimes output in keywords can be changed in minor version because of fixing wrong behaviour in past. Articles with examples 1. SQL Diagram (Part 3): SQL-to-ERD with DDL: https://levelup.gitconnected.com/sql-diagram-part-3-sql-to-erd-with-ddl-4c9840ee86c3 Updates in version 1.x The full list of updates can be found in the Changelog below (at the end of README). Version 1.0.0 was released due to significant changes in the output structure and a stricter approach regarding the scope of the produced output. Now, you must provide the argument 'output mode=name of your dialect' if you wish to see arguments/properties specific to a particular dialect How does it work? Parser supports: - SQL - HQL (Hive) - MSSQL dialect - Oracle dialect - MySQL dialect - PostgreSQL dialect - BigQuery - Redshift - Snowflake - SparkSQL - IBM DB2 dialect - Informix/GBase 8s dialect You can check dialects sections after Supported Statements section to get more information that statements from dialects already supported by parser. If you need to add more statements or new dialects - feel free to open the issue. Feel free to open Issue with DDL sample Pay attentions t","default_branch":null,"files":null,"tree":[],"storefront":"/r/xnuinside","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/xnuinside/simple-ddl-parser/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}