> TODO: description
npm install @dbml/coreRefer to @dbml/core for the complete API reference.
``bash
npm install @dbml/core
SQL Parser Feature Support
This section documents the SQL parsing capabilities for each supported database when importing SQL to DBML.
For more detailed documentation on each SQL parser, see the individual parser READMEs:
- PostgreSQL Parser
- MySQL Parser
- MSSQL Parser
- Oracle Parser
- Snowflake Parser
$3
| Symbol | Meaning |
|--------|---------|
| ✓ | Fully supported and correctly parsed |
| ◐ | Valid SQL that is parsed, but some options/clauses are ignored |
| ✗ | Valid SQL syntax, but the parser fails to generate output |
| — | Syntax not valid for this database |
$3
| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| Basic syntax | ✓ | ✓ | ✓ | ✓ | ✓ |
| Parameterized types (e.g.,
VARCHAR(255)) | ✓ | ✓ | ✓ | ✓ | ✓ |
| Array types (e.g., INTEGER[]) | ✓ | — | — | — | — |
| Enumerated types (ENUM) | ✓ | ✓ | — | — | — |
| Temporary tables | ◐ | ✗ | ✓ | ◐ | ◐ |
| CREATE TABLE AS SELECT | ✗ | ✗ | ✗ | ✗ | ✗ |
| Table options (ENGINE, TABLESPACE, etc.) | ◐ | ◐ | ◐ | ◐ | ◐ |
| Other column properties (COLLATE, etc.) | ◐ | ✗ | ◐ | ◐ | ◐ |
| Generated/Computed columns | ◐ | ◐ | ◐ | ◐ | ◐ |Notes:
- MSSQL:
- Temporary tables use
# prefix (local) and ## prefix (global)
- Square bracket identifiers ([identifier]) are supported####
PRIMARY KEY| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| Column-level | ✓ | ✓ | ✓ | ✓ | ✓ |
| Table-level | ✓ | ✓ | ✓ | ✓ | ✓ |
| Multi-column | ✓ | ✓ | ✓ | ✓ | ✓ |
| Explicitly named (
CONSTRAINT name) | ✓ | ✓ | ✓ | ✓ | ✓ |
| CLUSTERED/NONCLUSTERED | — | — | ◐ | — | — |####
FOREIGN KEY| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| Column-level (
REFERENCES) | ✓ | ✓ | ✗ | ✓ | ✗ |
| Table-level | ✓ | ✓ | ✓ | ✓ | ✗ |
| Multi-column | ✓ | ✓ | ✓ | ✓ | ✗ |
| Explicitly named (CONSTRAINT name) | ✓ | ✓ | ✓ | ✓ | ✗ |
| ON UPDATE action | ✓ | ✓ | ✓ | — | ✗ |
| ON DELETE action | ✓ | ✓ | ✓ | ✓ | ✗ |Notes:
- MSSQL: Column-level
FOREIGN KEY has a known bug - use table-level syntax instead
- Snowflake: All FOREIGN KEY definitions have a known bug producing undefined errors####
UNIQUE| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| Column-level | ✓ | ✓ | ✓ | ✓ | ✓ |
| Table-level | ✓ | ✓ | ✓ | ✓ | ✓ |
| Multi-column | ✓ | ✓ | ✓ | ✓ | ✓ |
| Explicitly named (
CONSTRAINT name) | ✓ | ✓ | ◐ | ✓ | ◐ |
| UNIQUE KEY/UNIQUE INDEX syntax | — | ✓ | — | — | — |####
CHECK| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| Column-level | ✓ | ✓ | ✓ | ✓ | ✗ |
| Table-level | ✓ | ✓ | ✓ | ✓ | ✗ |
| Explicitly named (
CONSTRAINT name) | ✓ | ✓ | ✓ | ✓ | ✗ |####
DEFAULT| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| Column-level | ✓ | ✓ | ✓ | ✓ | ✓ |
| Function as default | ✓ | ✓ | ✓ | ✓ | ✓ |
| Explicitly named (
CONSTRAINT name) | — | — | ◐ | — | ◐ |####
NOT NULL| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| Column-level
NOT NULL | ✓ | ✓ | ✓ | ✓ | ✓ |
| Explicit column-level NULL | ✓ | ✓ | ✓ | ✓ | ✓ |#### Auto-Increment Columns
| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
|
SERIAL (pseudo-type) | ✓ | — | — | — | — |
| BIGSERIAL (pseudo-type) | ✓ | — | — | — | — |
| AUTO_INCREMENT (column attribute) | — | ✓ | — | — | — |
| IDENTITY(seed, increment) (column property) | — | — | ✓ | — | ✓ |
| GENERATED AS IDENTITY (column property) | ✓ | — | ✗ | ✓ | ✗ |
| GENERATED ALWAYS AS IDENTITY | ✓ | — | — | ✓ | — |
| GENERATED BY DEFAULT AS IDENTITY | ✓ | — | — | ✓ | — |#### Inline Indexes
| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| Column-level indexes | — | ✗ | — | — | — |
| Table-level
INDEX/KEY | — | ✓ | — | ✓ | — |
| Named indexes | — | ✓ | — | ✓ | — |
| Multi-column indexes | — | ✓ | — | ✓ | — |
| USING BTREE/HASH | — | ✓ | — | — | — |
| FULLTEXT/SPATIAL | — | ◐ | — | — | — |---
$3
| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| Basic
CREATE INDEX | ✓ | ✓ | ✓ | ✓ | — |
| Multi-column index | ✓ | ✓ | ✓ | ✓ | — |
| UNIQUE index | ✓ | ✓ | ✓ | ✓ | — |
| Function-based index | ✓ | ✓ | — | ✓ | — |
| BTREE | ✓ | ✓ | ✗ | — | — |
| HASH | ✓ | ✓ | — | — | — |
| GIST | ✓ | — | — | — | — |
| BRIN | ✓ | — | — | — | — |
| GIN | ✓ | — | — | — | — |
| Partial/Filtered index (WHERE) | ◐ | ✗ | ◐ | ◐ | — |
| FULLTEXT | — | ◐ | ✗ | — | — |
| SPATIAL | — | ◐ | ✗ | — | — |Notes:
- MSSQL: Function-based indexes use computed columns instead
---
$3
| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| Basic
INSERT ... VALUES | ✓ | ✓ | ✓ | ✓ | ✗ |
| Multi-row INSERT | ✓ | ✓ | ✓ | — | ✓ |
| INSERT ... SELECT | ✗ | ✗ | ✗ | ✗ | ✗ |
| INSERT ... with returned rows (RETURNING, OUTPUT) | ◐ | — | ◐ | ◐ | — |
| INSERT ... ON CONFLICT/DUPLICATE KEY | ◐ | ◐ | — | — | — |Notes:
- Oracle: Uses
INSERT ALL syntax for multi-row inserts (not supported)---
$3
| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| ADD COLUMN | ✗ | ✗ | ✗ | ✗ | ✗ |
| DROP COLUMN | ✗ | ✗ | ✗ | ✗ | ✗ |
| ALTER/MODIFY COLUMN | ✗ | ✗ | ✗ | ✗ | ✗ |
| RENAME COLUMN | ✗ | ✗ | ✗ | ✗ | ✗ |
| ADD CONSTRAINT | | | | | |
| -
DEFAULT | ✗ | ✗ | ✓ | ✓ | ✗ |
| - NOT NULL | ✗ | ✗ | ✗ | ✓ | ✗ |
| - CHECK | ✓ | ✓ | ✓ | ✓ | — |
| - UNIQUE | ✓ | ✗ | ✓ | ✓ | ✓ |
| - PRIMARY KEY | ✓ | ✓ | ✓ | ✓ | ✗ |
| - FOREIGN KEY | ✓ | ✓ | ✓ | ✓ | ✓ |
| DROP CONSTRAINT | ✗ | ✗ | ✗ | ✗ | ✗ |---
$3
| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
| Table comments | ✓ | ✓ | ◐ | ✓ | ✓ |
| Column comments | ✓ | ✓ | ◐ | ✓ | ✗ |
| Comment syntax |
COMMENT ON | Inline COMMENT | sp_addextendedproperty | COMMENT ON | Inline COMMENT |Notes:
- MSSQL: Comments via
sp_addextendedproperty have unreliable parsing---
$3
| Feature | PostgreSQL | MySQL | MSSQL | Oracle | Snowflake |
|---------|------------|-------|-------|--------|-----------|
|
DROP TABLE | ✗ | ✗ | ✗ | ✗ | ✗ |
| DROP INDEX | ✗ | ✗ | ✗ | ✗ | — |
| ALTER INDEX | ✗ | — | ✗ | ✗ | — |
| CREATE VIEW` | ✗ | ✗ | ✗ | ✗ | ✗ |