SqlDelight 2.1.x Postgresql migrations with Liquibase

see https://github.com/griffio/sqldelight-postgres-01 for flyway migrations

https://github.com/cashapp/sqldelight

Some examples of newer postgresql support in sqldelight SNAPSHOT builds 2.1.x

Migrations performed

• create sequence
• add constraint foreign key
• set default - issue that default column must be populated by insert
• set not null
• drop not null
• drop column
• rename column - must manually rename column in queries
• rename table
• add check constraint
• drop identity - issue if table and column was previously renamed

To find bugs/issues that need to be fixed/implemented

Issues

• rename column - error with validation
  • AWAIT MERGE cashapp/sqldelight#4880
• alter table ... alter column ... drop identity - support but need fixing refers to old column if column was renamed
  • AWAIT FIX cashapp/sqldelight#4902
• alter table ... alter column ... set default - compilation error must be specified in insert statement
• sqm files must not have post-fix numbers e.g. V1_create_test_1.sqm as this breaks the ordering

Not supported

• alter/drop sequence
• alter table ... add constraint primary key ... (doesn't update data class property to non-nullable type)
• add constraint check, foreign key valid and not valid clauses

Bugs

• data class import missing in generated queries source when using star INSERT INTO City (city_name) VALUES (?) RETURNING *;
  • FIXED cashapp/sqldelight#4448
• allows unknown columns with alter table ... alter column - must show compiler error No column found to alter with name <unknown name>
  • AWAIT MERGE cashapp/sqldelight#4902

---

./gradlew build
./gradlew update

Liquibase db migrations https://contribute.liquibase.com/extensions-integrations/directory/integration-docs/gradle/