Skip to content

Convert Diff Forest to SQL Migration Queries #8

Description

@stifskere

Sub-issue of #3

Objective

Generate valid SQL migration queries from diff output.

Tasks

Stage 1: PostgreSQL CREATE TABLE (priority)

  • Generate ALTER TABLE statements for added columns, removed columns, and modified constraints.
  • Validate generated SQL runs correctly on PostgreSQL.

Stage 2: Full MVP / Other Dialects

  • Support MySQL, MariaDB, SQLite dialect-specific syntax.
  • Handle other schema elements (indexes, triggers).

Note: No Stage 1 for other dialects; prioritize Stage 1 PostgreSQL generation.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions