ddl_parser

sqllocks_spindle.schema.ddl_parser

Parse SQL CREATE TABLE DDL into SpindleSchema objects.

Supports SQL Server / Fabric Warehouse, PostgreSQL, MySQL, and ANSI SQL via regex-based parsing (no external SQL parser dependency).

Classes

DdlParser

Parse SQL DDL (CREATE TABLE) into a SpindleSchema.

Supports SQL Server / Fabric Warehouse, PostgreSQL, MySQL, and ANSI SQL via regex-based parsing. No external SQL parser dependency required.

Usage::

parser = DdlParser()
schema = parser.parse_file("my_tables.sql")
# or
schema = parser.parse_string("CREATE TABLE ...")

Methods:

parse_file(path)

Parse a .sql file containing CREATE TABLE statements.

parse_string(sql)

Parse SQL DDL string into a SpindleSchema.