#669·drawdb

[BUG] Importing SQL (PostgreSQL) with Foreign Key reference does cause a SyntaxError

Author: emschuCreated Oct 29, 2025Updated Aug 30, 2026

Describe the bug Importing the provided test SQL (in PostgreSQL dialect) does not work and fails with a false-positive SyntaxError. The given test SQL is valid in Postgres dialect.

To Reproduce Steps to reproduce the behavior:

  1. Open the application
  2. Click on "File" -> "Import from SQL"
  3. Import an .sql-file with the test content below
  4. See error: "SyntaxError [Ln 13, Col 1]: Expected "(", "--", ".", "/*", or [ \t\n\r] but ")" found."

Test SQL content:

ddl_test.sql ddl_test_extended.sql

sql
create table test.table1
(
    id uuid not null
        primary key
);

create table test.table2
(
    id     uuid not null
        primary key,
    ref_id uuid
        references table1
);

Expected behavior The import of the SQL file should work.

Screenshots Image

Desktop (please complete the following information):

  • OS: Windows
  • Browser Chrome

Additional context The second test file is slightly extended (one more column) and results in a different Syntax Error:

txt
SyntaxError [Ln 12, Col 26]: Expected "(", "--", ".", "/*", [ \t\n\r], or [A-Za-z0-9_\-$一-龥À-ſ] but "," found.