sql-formatter-org / sql-formatter / 25882945441

96%

push

github

Add support for PostgreSQL keywords in CREATE CONSTRAINT TRIGGER (#948)

Config:

```js
language: 'postgresql',
keywordCase: 'upper',
identifierCase: 'lower',
```

Before:

```sql
CREATE CONSTRAINT TRIGGER example_trigger
AFTER insert
OR
UPDATE of column_a,
column_b ON example_table DEFERRABLE INITIALLY deferred FOR each ROW
EXECUTE procedure example_function ();

CREATE TRIGGER example_trigger
AFTER insert
OR
UPDATE
OR delete ON example_table FOR each ROW
EXECUTE function example_function ();
```

After:

```sql
CREATE CONSTRAINT TRIGGER example_trigger
AFTER INSERT OR UPDATE OF column_a,
column_b ON example_table
DEFERRABLE INITIALLY DEFERRED FOR EACH ROW
EXECUTE PROCEDURE example_function ();

CREATE TRIGGER example_trigger
AFTER INSERT OR UPDATE OR DELETE ON example_table FOR EACH ROW
EXECUTE FUNCTION example_function ();
```

<!-- This is an auto-generated comment: release notes by coderabbit.ai
-->
## Summary by CodeRabbit

* **Bug Fixes**
* PostgreSQL formatting now recognizes additional reserved multi-word
phrases and variants (improves handling of trigger/constraint event
clauses, EXECUTE forms, AFTER/DEFERRABLE variants, and FOR EACH ROW) for
more accurate SQL output.

* **Tests**
* Added regression tests verifying CREATE CONSTRAINT/TRIGGER formatting
and correct casing preservation for keywords and identifiers.

<!-- review_stack_entry_start -->

[![Review Change
Stack](https://storage.googleapis.com/coderabbit_public_assets/review-stack-in-coderabbit-ui.svg)](https://app.coderabbit.ai/change-stack/sql-formatter-org/sql-formatter/pull/948)

<!-- review_stack_entry_end -->
<!-- end of auto-generated comment: release notes by coderabbit.ai -->

574 of 644 branches covered (89.13%)

Branch coverage included in aggregate %.

1310 of 1328 relevant lines covered (98.64%)

16313.53 hits per line