# What changed in prettier-plugin-sql-cst

> 13 changes in prettier-plugin-sql-cst 0.22 to 0.23 from its official release notes, upgrade guides and advisories: 1 breaking. Each one cited. Sources checked 2026-10-19. HTML: https://unstale.sh/npm/prettier-plugin-sql-cst/

To see which of these apply to a repository, run `npx @unstale/cli init` in it.

## prettier-plugin-sql-cst 0.23

### Breaking changes

- PostgreSQL -> and ->> operators are formatted without spaces around them. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)

### Behavior and default changes

- CREATE INDEX formatting is improved. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)
- Empty parentheses after a function name no longer get a line break. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)
- SQL inside PL/pgSQL EXECUTE and BigQuery EXECUTE IMMEDIATE is formatted. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)
- JOINs are formatted at the same indentation level as FROM. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)
- PL/pgSQL and SQL inside PostgreSQL DO statements are formatted. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)
- A single-column SELECT no longer uses a hanging indent. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)
- CASE expressions use improved WHEN/THEN/ELSE formatting. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)

### Fixes and other changes

- Long binary expressions break after the operator. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)
- COMMENT ON formatting is improved. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)
- Parentheses in count(DISTINCT (foo, bar)) are preserved. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)
- Strings in the LANGUAGE clause are recognized. (0.23.0) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.23.0)

## prettier-plugin-sql-cst 0.22

### Fixes and other changes

- Formatting of `-------------` comments is preserved. (0.22.1) — [release notes](https://github.com/nene/prettier-plugin-sql-cst/releases/tag/v0.22.1)