Migrations that add and drop columns creates syntax error

[sc68cal]

This is with 598b491 and I haven't checked to see if this is present in the released version.

pub fn up(repo: anytype) !void {
    try repo.alterTable(
        "locations",
        .{
            .columns = .{
                .add = &.{
                    t.column("lat", .float, .{}),
                    t.column("lon", .float, .{}),
                },
                .drop = &.{
                    "state",
                    "zip",
                },
            },
        },
    );
}

/
| Query:
|   ALTER TABLE "locations" ADD COLUMN "lat" REAL NOT NULL, ADD COLUMN "lon" REAL NOT NULL DROP COLUMN "state", DROP COLUMN "zip"
| Error:
|   PG: syntax error at or near "DROP"
\

[sc68cal]

Current workaround is to split it into two separate calls

pub fn up(repo: anytype) !void {
    try repo.alterTable(
        "locations",
        .{
            .columns = .{
                .add = &.{
                    t.column("lat", .float, .{}),
                    t.column("lon", .float, .{}),
                },
            },
        },
    );
    try repo.alterTable(
        "locations",
        .{
            .columns = .{
                .drop = &.{
                    "state",
                    "zip",
                },
            },
        },
    );
}

[bobf]

I think it would be a simple fix to automatically split this into two calls - I'll take a look over the weekend.