SQL Creator

SQL Creator generates SQL migration queries by diffing two ASTs (Abstract Syntax Trees) representing database schemas. Version 0.54.0 is the latest stable release. It is used to programmatically produce ALTER TABLE, CREATE TABLE, DROP TABLE, and similar statements from a 'from' and 'to' AST. It is distinct from migration tools like Knex or TypeORM because it operates purely on ASTs and does not require a specific ORM or database driver. The library focuses on schema comparison rather than executing migrations or managing versions. It supports PostgreSQL and MySQL dialects.