better formatting

[xenoterracide]

Thanks for creating this project, it's pretty awesome.

I've encountered some formatting issues though. So when I formatted, this is my result

--changeset ccushing:0004-money
  create table currency (
    id uuid primary key not null default uuid_generate_v4(),
    code text not null,
    description text,
    notes text,
    created_at timestamp with time zone default now() not null,
    created_by text default ("current_user"()) :: text not null,
    modified_at timestamp with time zone default now() not null,
    modified_by text default ("current_user"()) :: text not null,
    deleted boolean default false not null,
    deleted_at timestamp with time zone,
    deleted_by text
  );
create unique index if not exists public_currency_idx on currency (code)
where
  deleted_at is null;
create unique index if not exists public_currency_deleted_idx on currency (code)
where
  deleted is false;
create trigger t_public_currency before
update on currency for each row execute procedure public.f_update_modified_records();
insert into currency (code)
values
  ('USD');
--changeset ccushing:0004-01-add-payment-methods stripComments:true

what I'd like to get is whitespace between statements and before comments, and column align types.

--changeset ccushing:0004-money
  create table currency (
    id                  uuid primary key not null default uuid_generate_v4(),
    code             text not null,
    description  text,
    notes            text,
    created_at    timestamp with time zone default now() not null,
    created_by   text default ("current_user"()) :: text not null,
    modified_at  timestamp with time zone default now() not null,
    modified_by text default ("current_user"()) :: text not null,
    deleted         boolean default false not null,
    deleted_at    timestamp with time zone,
    deleted_by    text
  );

create unique index if not exists public_currency_idx on currency (code)
where
  deleted_at is null;

create unique index if not exists public_currency_deleted_idx on currency (code)
where
  deleted is false;

create trigger t_public_currency before
update on currency for each row execute procedure public.f_update_modified_records();
insert into currency (code)
values
  ('USD');

--changeset ccushing:0004-01-add-payment-methods stripComments:true

it's worth noting before I formatted that this whitespace was in place.

it would also be nice to have the option to uppercase sql keywords

[mtxr]

Hey @xenoterracide!

The option to uppercase words already exists.
Try this:

"sqltools.format": {
  "reservedWordCase": "upper"
},

the column alignment for types you can achieve using other extensions that you can find in the market place.

https://marketplace.visualstudio.com/items?itemName=matthewthorning.align-vertically
https://marketplace.visualstudio.com/items?itemName=Gruntfuggly.align-mode

I don't plan to add it here now because the extension is growing a lot and there are a lot of changes between v0.21 -> v0.22 already. So since we have an alternative for this, I'll close the issue.