Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

[Unreleased]

v2.48.0 - 2026-04-18

Added

linter: add require-table-schema rule (#1046, #1064, #1073). Thanks @Flaiers!

Note: this rule is disabled by default and must be enabled via the new --include flag.
```
-- error
create table posts(id bigint);

-- okay
create table public.posts(id bigint);
```
parser: improve error recovery for misplaced join clauses (#1065)

The following now gives a concise error message:
```
-- join after the where
select * from t
where x > 1
join k on true;
```
parser: support more statement kinds in create schema parsing (#1061)
ide: semantic syntax highlighting improvements (#1059, #1060, #1068)

We now highlight all the tokens in types. We were missing some like setof.

Additionally, we highlight names by their underlying kind i.e., table, function, column. This is powered by goto def.

You can't tell from GitHub's highlighting, but if you use the language server, we now highlight the b in t.b as a function:
```
create table t(a int);
create function b(t) returns int as 'select 1' language sql;
select b(t), t.b from t;
```
ide: show function comment on hover (#1070)
ide: code action to rewrite between != and <> (#1066)
ide: goto def for create property graph (#1074)

Fixed

parser: fix param parsing (#1068)

Before, double precision was parsed as a param named double with type precision. Now it's parsed correctly as an unnamed param of type double precision.
```
create function f(double precision) returns int8
  as 'select $1'
  language sql;
```

v2.47.0 - 2026-04-13

Added

ide: semantic syntax highlighting (#1057, #1058, #1052)
ide: semantic syntax highlighting (#1048)
playground: update syntax highlighting language with codegen'd keywords (#1055, #1054)
vscode: update syntax highlighting to support more operators (#1047)
ide: goto def for user, current_user, session_user, & current_schema (#1056)

v2.46.0 - 2026-04-05

Added

ide: goto def support for dec & float(n) types (#1042)
vscode: vendor and improve postgres syntax highlighting grammar (#1043, #1041, #1039)
parser: sync pg regressions suite & support the new ForPortionOf clause (#1038)

Fixed

ide: fix column naming for dec & float(n) (#1040)

v2.45.0 - 2026-04-01

Added

server: add multi threading (#1032, #1031, #1030, #1029, #1028, #1026, #1024, #1018)
parser: improve error recovery for expr_as_name_list (#1017)
parser: sql/pgq cleanup & more sql/pgq test cases (#1016)
parser: improve persistence parsing (#1013)

Internal

internal: bump rust to 1.94 (#1015)

v2.44.0 - 2026-03-19

Added

linter: add require-enum-value-ordering rule (#992). Thanks @cabello!
linter: add cross-file validation for NOT NULL constraint pattern (#957). Thanks @reteps!
parser: support postgres 18 graph language (#1010)
parser: support new except table clause (#986)
parser: alter type ast improvements (#993)
playground: add code folding support (#1000)
ide: folding range support (#999)
ide: goto def window defs & over clauses (#994)
ide: goto def subquery compound selects (#988)

Fixed

server: handle errors from handlers by converting to a lsp err response (#1005)
parser: we weren't handling compound selects with extra parens (#989)

Changed

server: pull based diagnostics (#1006)

Internal

internal: replace lazy_static with std::sync::OnceLock (#1009)
internal: HashMap -> FxHashMap, FxHashSet (#1007)
server: refactor notification handling to embrace types (#1004)
server: refactor request handling to embrace types (#1003)
server: refactor lib.rs into separate files (#1002)
ide: add thread module from rust-analyzer (#1001)
parser: sync plpgsql test suite from postgres (#991)
ide/playground: salsa most of the server functions (#981)
ide: update sql stub codegen to include some extensions (#984)

v2.43.0 - 2026-02-28

Added

ide: quick action for timestamp with out timezone to timestamptz (#976)
ide: goto def for create aggregate params (#972)
ide: hover/goto def for subquery w/ alias (#970)
ide: lateral joins, subqueries with table, hover aliases (#969)
ide: support table alias with column list (#968)

Fixed

linter: fix ignore comment not working with trailing content (#975)
ide: fix column name infer & related goto def (#977)
syntax: update ast with missing detach partition fields (#978)
ide: fix builtin aggregates being defined as functions (#971)
ci: fix arm musl build (#966)

Internal

ide: refactor hover to use goto def (#967)

v2.42.0 - 2026-02-25

Changed

linter: undo foreign key constraint check in create table (#962)

This was an incorrect change to add and isn't necessary since the new table doesn't have any rows.

Added

ci: build for alpine arm (#960)
ide: code action - rewrite between as binary expression (#953)
ide: goto def & hover for now() + current_timestamp (#950)
ide: goto def for column names in table function returns (#949)
ide: goto def with function in from item & cross join (#961)

Fixed

ide: fix col names for collation for, at time zone, overlaps (#951)

v2.41.0 - 2026-02-20

Added

linter: warn about foreign key constraints in create table defs (#945)
parser: support on conflict do select & sync regression suite (#935)
parser: improve create function table return type parsing (#944)
ide: find ref support for builtins (#942)
ide: support inherits/like tables in inlay hints (#936)
ide: add quick fixes for leading from (#933)
ide: goto def for builtins (#932)

Fixed

linter: fix adding-not-nullable-field for pg >= 12 with validated CHECK (#910). Thanks @reteps!

Changed

linter: don't report lint errors when syntax error found (#943)

v2.40.1 - 2026-02-12

Fixed

github: fix commenting via rust_crypto features in jsonwebtoken (#929). Thanks @lokiwins!

Added

parser: parse leading from clauses but warn they're not supported (#927)

from t select c;

now gives:

   error[syntax-error]: Leading from clauses are not supported in Postgres
  ╭▸ stdin:1:1
  │
1 │ from t select c;
  ╰╴━━━━━━

We also check for solo from clauses:

from t;

gives:

  error[syntax-error]: Missing select clause
  ╭▸ stdin:1:1
  │
1 │ from t
  ╰╴━

parser: fix parsing any/all/some in exprs (#926)

select * from t order by all

now properly errors:

   error[syntax-error]: expected expression in atom_expr
  ╭▸ stdin:1:26
  │
1 │ select * from t order by all
  ╰╴                         ━

Before it parsed all as a name reference.

ide: goto def func call in on conflict (#925)

v2.40.0 - 2026-02-06

Added

parser: improve error recovery in where, having, & join on (#911, #912)
ide: goto def on conflict clause (#907)
ide: goto def func calls inside constraints/columns/indexes/partitions (#906)

Fixed

ide: goto def with recursive CTEs (#909)

v2.39.0 - 2026-01-31

Added

vscode: add report issue command using the builtin issue reporter (#897)
ide: goto def on comment on stmts (#894)
ide: goto def with create table as (#893)
ide: document symbols for create policy (#892)
ide: goto def with policy stmts (#886, #887, #888)

Changed

linter: undo ignoring single stmts in prefer-robust-stmts (#902)

Fixed

ide: fix goto def for func call inside func (#901)
docs(readme): bump version of squawk in pre-commit demo v0.10.0 to v2.38.0 (#889). Thanks @dzhalaevd!

v2.38.0 - 2026-01-24

Added

parser: add more nodes for create policy/alter policy ast (#884)
parser: cte error handling improvements (#881)
ide: completions for more clauses in select (#883)
ide: complete * in select clauses (#880)
ide: improve select completions with completion marker (#879)
ide: hover support for subquery columns (#878)
ide: include types in completions (#877)
ide: goto def with function param in create op (#876)
ide: goto def support for domains (#872)
ide: goto def on multiranges & timestamp timezones (#870)
ide: function signature in completion (#869)

Changed

ide: update cast rewrites to support select type 'foo' (#868)

Fixed

ide: fix column name for real type (#874)
ide: fix goto def with cte & table of same name (#873)
parser: fix unicode escape strings being parsed as byte strings (#871)
ide: fix type alias goto def, bigint -> int8, smallint -> int2, etc. (#867)
parser: fix parsing cast operator with array type (#866)

v2.37.0 - 2026-01-18

Added

ide: cast function <-> cast operator code actions (#834)
ide: values <-> select code actions (#846, #847)
ide: insert schema code action (#855, #856)
code completion
- ide: delete from completion improvements (#861)
- ide: completion for truncate, table, select (#857)
- ide: code completion in playground & prettier upgrade (#859)
- ide: code completion for schemas (#858)
many goto def & hover improvements
- ide: goto def for create/alter/drop role (#854)
- ide: create/alter/drop event trigger (#852)
- ide: listen/notify/unlisten (#851)
- ide: goto def with create/drop trigger (#850)
- ide: goto def/hover/document symbol support for prepare stmt (#849)
- ide: add support for declare/fetch/move/close cursor (#848)
- ide: better goto def support for returning clause in insert/update/delete (#828)
- ide: improved goto def & hover for merge stmts (#830)
- ide: goto def/hover for like and inherits clauses (#832)
- ide: goto def nested table/values (#844)
- ide: goto def with column list alias (#843)
- ide: goto def on function using table as type (#842)
- ide: goto def on named params & special functions (#841)
- ide: goto def on extensions (#840)
ide: inlay hints for select in insert stmt (#845)
parser: improve error handling for unfinished select stmt (#838)
playground: expand selection support (#829)

Changed

parser: update role grammar to use refs like names (#853)

Fixed

ide: fix default search path to include pg_catalog (#864)

v2.36.0 - 2026-01-06

Added

ide: goto def support for merge (#826),(#825)
ide: goto def truncate, lock, vacuum, alter table column, refresh (#823)
ide: document symbol support for create view (#807)
ide: goto def create/alter/drop server (#821)
ide: goto def foreign tables (#820)
ide: use previous token in more cases of punctuation (#819)
ide: support hover with * in queries (#818)
ide: goto def support for references column constraints & select t.* from t; (#817)
ide: support find references for join using clause (#816)
ide: goto def using clause in join (#815)
ide: goto def for tablespace (#814)
ide: better goto def with create table (#813)
ide: mat view goto def/hover, agg/procedure/mat view doc symbols (#812)
ide: better goto def support for types (#811)
ide: composite field goto def & hover (#810)
ide: document symbol support for CTEs (#806)
ide: hover for views (#804)
ide: goto def with create view (#802)
vscode: restart server command (#808)

Fixed

ide: fix column name for special cased functions (#824)
playground: fix dupe hover results in editor (#805)

v2.35.0 - 2026-01-02

Added

ide: add goto def & hover support for types in casts (#799)
ide: add initial goto def support for types (#798)
ide: support ctes with update (#797)
ide: hover with update (#796)
ide: goto def with update (#795)
ide: goto def with insert/delete & CTE (#794)
ide: goto def for joins (#793)
ide: goto def & hover with procedures (#792)
ide: table alias goto def support (#791)
ide: hover for create aggregate (#789)
ide: goto def for aggregates (#788)
ide: cte improvements, subqueries, values, union select (#787)
ide: code action to remove redundant alias (#785)
ide: add hover to cte table & columns (#784)
ide: support more CTEs in goto def (#783)
ide: goto def with cte & select (#782)
ide: code action for making inferred column alias explicit (#781)
playground: inlay hints, doc symbols, hover, goto def/refs, actions (#779)
ide: add columns to document symbols (#778)
ide: add document symbols (#777)
ide: support hover & goto def for function call style columns in where (#776)
ide: support func call syntax in select (#775)
ide: support goto def on schema (#774)
ide: support hover for delete, insert, and select targets (#773)
ide: goto def & hover tables refs in from clause (#772)
ide: inlay hints for insert & add goto def for hints (#771)
ide: goto def for insert and delete (#770)
ide: inlay hints for function calls (#769)
ide: function call goto def and hover (#768)
ide: add hover for create function (#767)
ide: goto def with create & drop function (#766)
ide: add hover for create index (#765)
ide: add hover for create table (#764)
ide: add hover for column in create index (#763)
ide: goto def on create/drop index (#762)
ide: add basic find refs support (#760)

Fixed

parser: fix parsing group by all in CTE (#780)
ide: fix goto def with temp table (#761)

v2.34.0 - 2025-12-22

Added

parser: add support for postgres 19's partition merge, partition split, and more. (#754)
parser: handle missing exprs in case expr (#749)
ide: goto def with table stmt (#748)
ide: support set search_path (#747)

Internal

fix: Removed deprecated cargo_bin() function in snapbox (#746). Thanks @ranger-ross!

v2.33.2 - 2025-12-16

Fixed

ci: try to fix npm trusted publishing (#742)

v2.33.1 - 2025-12-16

Fixed

ci: npm trusted publishing (#741)

v2.33.0 - 2025-12-16

Added

ide: goto def create temp table (#737)
ide: basic goto def for create table/drop table (#736)
ide: goto def on begin/commit/rollback (#734)
ide: quote & unquote identifiers (#733)
ide: add table <-> select rewrites (#728)
ide: string rewrites (#725)
parser: update grammar & ast (#727)
use npm trusted publishing (#724). Thanks @chdsbd!

Fixed

linter: fix false positive with create temp table t() on commit drop; (#739)
parser: fix reindex parsing (#726)

v2.32.0 - 2025-12-04

Fixed

parser: fixed issue parsing some insert's with selects and conflict clauses (#720, #721, #722).

Added

parser: special case functions like extract are now properly typed in the ast (#719).

v2.31.0 - 2025-11-24

Added

linter: adding_foreign_key_constraint: allow when create table in transaction (#713)
lsp: add code action for case else clause (#709). Thanks @cr4ftx!
lsp: go to def for case exprs (#708)
parser: fill out more ast nodes (#714)
parser: add slice expr node to syntax tree (#707)
parser: improve create function & create foreign table robustness (#704)
parser: improve option & role lists (#702)
parser: improve error recovery for update statements (#701)

Fixed

parser: fix nodes for casts so ast access works correctly (#711)
linter: fix autofix for int & smallint with array types (#710)

v2.30.0 - 2025-10-30

Added

linter: new rule ban-uncommitted-transaction

Squawk now warns about missing commit statements like:

begin;
create table t(id bigint);

warning[ban-uncommitted-transaction]: Transaction never committed or rolled back.
  ╭▸ stdin:1:1
  │
1 │ begin;
  │ ━━━━━
  │
  ├ help: Add a `COMMIT` or `ROLLBACK` statement to complete the transaction.
  ╭╴
2 ±
3 + COMMIT;
  ╰╴

v2.29.0 - 2025-10-19

Added

parser: improve error recovery for option lists in reindex, prepare, vacuum, copy, drop database, create type, create function, create table, create index (#684)

parser: improved error recovery for CTEs (#683)

with
  a as (
     select 1
  ) -- <-- missing a comma
  b as (
     select 3
  )
select 2;

squawk now identifies the missing comma correctly:

  error[syntax-error]: missing comma
  ╭▸ stdin:4:6
  │
4 │     ) -- <-- missing a comma
  ╰╴     ━

parser: improve error recovery of group by & distinct on (#695)
vscode: improved commenting behavior (#690)

Fixed

linter: fixed false positive with constraint-missing-not-valid (#694)
lexer: lex empty dollar quoted strings ($$$$) correctly (#691)
linter: identify table statement as fast (#688)
lsp: server logs no longer contain ansi codes which vscode garbles (#681)

v2.28.1 - 2025-10-03

Added

lsp server: expand selection support. (#674)

Fixed

linter: fix require-timeout-settings false positives with create table statements that do not have foreign keys. (#675)

v2.28.0 - 2025-10-02

Added

New rule: require-timeout-settings (#671)

It's important to configure lock & statement timeouts to ensure safe migrations. See Safety Requirements

So the following will error:
```
alter table t add column c boolean;
```
but this is okay:
```
set lock_timeout = '1s';
set statement_timeout = '5s';
alter table t add column c boolean;
```
If you've already configured timeouts for your migrations, you can safely ignore this rule.

Fixed

parser: pg18 like clause in create foreign table now parses (#666)
cli: parsing rule alises i.e., prefer-timestamptz and prefer-timestamp-tz both work. (#668)

v2.27.0 - 2025-09-23

Added

cli: rendering of diffs for suggestions in output. (#662)

We now include a diff below the rule error.

warning[require-concurrent-index-creation]: During normal index creation, table updates are blocked, but reads are still allowed.
   ╭▸ example.sql:10:1
   │
10 │ CREATE INDEX "field_name_idx" ON "table_name" ("field_name");
   │ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
   │
   ├ help: Use `concurrently` to avoid blocking writes.
   ╭╴
10 │ CREATE INDEX concurrently "field_name_idx" ON "table_name" ("field_name");
   ╰╴             ++++++++++++

Fixed

parser: parsing some set related commands. (#657)

The following now parse:

set schema 'foo';
set foo.bar from current;
set bar from current;

Changed

internal: bump rust to 1.90.0 (#659)
syntax: fill out more of the ast (#658)

v2.26.0 - 2025-09-15

Added

linter: adding-field-with-default now allows more cases (#652).

alter table t add column c text[] default array[]::text[];
alter table t add column c timestamptz default current_timestamp;

-- const/non-volatile binary expressions are also allowed
alter table t add column c timestamptz default now() - interval '100 years';

Fixed

parser: parse materialized views using a paren select (#651).

The following now parses:
```
create materialized view v
as (select * from t);
```

Changed

cli now uses unicode for snippet annotations (#654).

v2.25.1 - 2025-09-03

Fixed

github: fix api calls failing with 403. (#643)

v2.25.0 - 2025-09-02

Added

linter: --no-error-on-unmatched-pattern argument to not exit with an error if no files are matched (default: false) (#639). Thanks @PascalFrenz!
linter: gitlab reporter (#624). Thanks @benedikt-bartscher!

Fixed

linter: adding-field-with-default now checks that the postgres version is <= 11 before reporting an error for non-volatile defaults (#637). Thanks @ermakov-oleg!
linter: github commenting truncates when too large (#605). Thanks @ienugr!
parser: parsing path's named operator now works (#640).

Previously the following would error:
```
create table operator();
```
squawk_syntax: ast::BinExpr lhs & rhs properties now work correctly (#634).
internal: bumped a bunch of outdated JS & Rust dependencies (#630), (#631), (#632), (#633).

v2.24.0 - 2025-08-24

Added

linter: quick fixes for prefer-text-field (#621), ban-char-field (#620), prefer-bigint-over-int, prefer-bigint-over-small-int (#618), and prefer-timestamptz (#617).

Fixed

Fixed typos in linter docs (#623). Thanks @benedikt-bartscher!
linter: fix ban-char-field to be case insensitive (#619).

v2.23.0 - 2025-08-20

Added

github: support overriding api url for github enterprise usage (#611). Thanks @jvatic!
lsp server: quick fix to open documentation for rule violation (#610)
lsp server: quick fixes to ignore rules for a line or entire file (#613)

Fixed

linter: violations no longer include leading whitespace & comments in their range. (#612)

v2.22.0 - 2025-08-07

Added

linter: add fixes for prefer-robust-stmts (currently LSP server only) (#602)
playground: add quick fix support (#606)

Fixed

linter: fix comparison edge cases with identifiers (#600), (#601). Thanks @gilbsgilbs!

v2.21.1 - 2025-07-23

Fixed

parser: bugged warning for invalid casts that was warning about all casts inside function calls. (#598)

v2.21.0 - 2025-07-23

Added

parser: warn about try_cast and don't fail to parse casts that are invalid. (#593)

Fixed

vscode: invalid binary path on windows causing extension not to load. (#595)

v2.20.0 - 2025-07-12

Added

GitHub annotations when run with GITHUB_ACTIONS set. (#589), (#590)

This can be disabled by setting SQUAWK_DISABLE_GITHUB_ANNOTATIONS.
Docs for squawk-ignore-file. (#588)
Publishing to open vsx in CI. (#587)

v2.19.0 - 2025-07-09

Added

linter: file level rule violation ignore comments. (#585)

Now you can ignore all violations in a file via:
```
-- squawk-ignore-file
```
or ignore a specific rule for the file:
```
-- squawk-ignore-file prefer-robust-stmts
```
This works with the existing line level ignores:
```
create table t (id int);
-- squawk-ignore prefer-robust-stmts
create table u (id int);
```
vscode: incremental sync. (#583)

No more debouncing of file updates making squawk in vscode snappier!
vscode: tracing setting squawk.trace.server & output channel. (#584), (#585)

v2.18.0 - 2025-07-03

Added

vscode: Show tokens command to get lexer output. (#579)
vscode: Show server & Stop server commands. (#576)
vscode: show client logs & show syntax tree commands. (#575)

v2.17.0 - 2025-06-30

Added

Basic VSCode extension. (#567), (#569), (#571), (#572)
Improved json_table parsing. (#564)

v2.16.0 - 2025-06-27

Added

Parsing non-standard placeholders with format :name. (#560), (#561)
Error recovery for drop table when there's extra commas or missing commas. (#556)
Improved order by parsing. (#556)
Error recovery for array exprs & improvements for constraints. (#557)
Improved CTE parsing. (#558)
Error recovery for type args & more forgiving create table args parsing. (#559)

Changed

Internal: bumped rust to 1.88.0

v2.15.0 - 2025-06-21

Added

validation for missing types in create table args. (#550)

The following now parses with an error:

create table t (
  x int,
  description
);

error[syntax-error]: Missing column type
 --> stdin:3:14
  |
3 |   description
  |              ^
  |

Make alter table actions robust to missing commas. (#549)

The following now parses with an error:

alter table t
  validate constraint foo
  validate constraint b;

error[syntax-error]: missing comma
 --> stdin:2:26
  |
2 |   validate constraint foo
  |                          ^
  |

Fixed

Crash with trailing comma in select target list. (#551)

The following now parses with an error:

select a, from t;

error[syntax-error]: unexpected trailing comma
--> stdin:1:9
|
1 | select a, from t;
|         ^
|

Parsing idents with uescape. (#533)

The following now parses:
```
select U&"d!0061t!+000061" UESCAPE '!';
```

v2.14.0 - 2025-06-17

Added

The npm install script now checks an env var (SQUAWK_LOCAL_CDNURL), that defaults to https://github.com/sbdchd/squawk/releases/download, for downloading binaries. This should help when you want to use a cache or in case GitHub is down.

Fixed

The last of the pg regression suite errors. (#543), (#542)

Precendence when parsing compound select statements. (#544)

SELECT foo UNION SELECT bar ORDER BY baz;
-- equal to:
(SELECT foo UNION SELECT bar) ORDER BY baz;

v2.13.0 - 2025-06-15

Fixed

parsing compound select statements & their trailing clauses, i.e. (#539)

(select 1) limit 1;

select * from (
  (select 1)
  union all
  (select 1)
);

join parsing to be more error resilent: (#538)

error[syntax-error]: Join missing condition.
 --> stdin:2:23
  |
2 | select * from t join u;
  |                       ^
  |
error[syntax-error]: Join `using` clause is not allowed for cross joins.
  --> stdin:16:30
   |
16 | select * from t cross join u using (id);
   |                              ^^^^^^^^^^
   |
error[syntax-error]: Join condition is not allowed for cross joins.
  --> stdin:18:30
   |
18 | select * from t cross join u on true;
   |                              ^^^^^^^
   |

v2.12.0 - 2025-06-09

Changed

Relicensed: gpl3 -> apache or mit (#534)

Fixed

json_table, table, values, group by (#536)
Cast expression issues (#533)
Float lexing (#532)
Unicode escaped quoted idents (#531)
xmltable (#530)
Many parser fixes for the pg regression test suite (#529), (#527), (#526), (#524), (#523), (#522)

v2.11.0 - 2025-05-30

Fixed

Fix regression in linter rule adding-not-nullable-field from v2 rewrite. It wasn't erroring when it should have. (#520)
Fix parser panic related to select json_array(select from t); (#515)
Fix more parser errors in PG regression suite. notnull now parses! (#516)
Fix more parser errors in PG regression suite part 2. Notably ilike is now supported. (#518)

v2.10.0 - 2025-05-27

Fixed

Fix typo in rule name parsing causing unused-ignore to warn for prefer-timestamp-tz. (#511)

Fix parsing window definition. (#510)

Previously the following would error:

WITH ranked_notifications AS (
  SELECT
    notification_id,
    ROW_NUMBER() OVER (
      PARTITION BY user_id, board_id ORDER BY created_at DESC
    ) AS rn
  FROM public.notification
  WHERE android_channel_id = 'watchlist'
)
UPDATE public.notification
SET dismissed_at = current_timestamp
WHERE notification_id IN (
  SELECT notification_id FROM ranked_notifications WHERE rn > 1
);

v2.9.0 - 2025-05-25

Added

Added back basic dump ast support via squawk --debug=ast. (#505)

v2.8.0 - 2025-05-25

Fixed

Fix parsing select select. (#499)

Previously, the following would panic:
```
select select
```
Fix displaying warnings as errors. (#502)

We were highlighting warnings using the error syntax (red ^ instead of yellow -). We also were rendering syntax errors as warnings instead of errors!
Fix parsing aggregate args with modifiers like distinct or all. (#498) Thanks @psteinroe!

Previously the following would error:
```
select string_agg(distinct c, ',')
  filter (where length(c) > 1)
  from t;
```

Fix parsing data sources within params. (#497) Thanks @psteinroe!

Previously the following would error:

select f1, count(*) from
  t1 x(x0,x1) left join (t1 left join t2 using(f1)) on (x0 = 0)

Fix parsing alternative boolean keywords. (#493) Thanks @psteinroe!

Previously the following would error:
```
explain (costs off) select;
```

Changed

Renamed ast::Item to ast::Stmt. (#483)
Split select into select, tables, and values statements. (#484)

v2.7.0 - 2025-05-14

Fixed

Fix parsing table constraint foreign key actions. (#480)

Previously, the following would error:

alter table foo
add constraint foo_bar_id_fkey foreign key (bar_id)
references bar (id) on update cascade on delete cascade;

v2.6.0 - 2025-05-14

Fixed

Fix the GitHub commenting overwriting comments made by other bots sharing the same name, i.e., the default GitHub Action bot. (#477) Thanks @danxmoran!

v2.5.0 - 2025-05-14

Fixed

Fixed parsing create or replace view (#474).

Previously, the following would error:
```
create or replace view my_view as
  select x from foo;
```

v2.4.0 - 2025-05-13

Fixed

Fixed parsing create view with nested parens (#468).

v2.3.0 - 2025-05-13

Fixed

Parsing grant and revoke statements with schema specified names, aka the following parses correctly: (#469)
```
GRANT ALL ON SEQUENCE public.s TO u;
```

v2.2.0 - 2025-05-12

Added

Style guide for linter error messages

Fixed

Error messages for prefer-robust-statements to be less confusing. We were saying to add if not exists every time, even when the statement didn't have that option.

Fixed parsing nested compound select that has parens (#464). The following now parses:

SELECT (
  (SELECT id FROM code_categories WHERE "language" = @language::char(4) ORDER BY "id" ASC LIMIT 1)
  UNION
  (SELECT id FROM code_categories WHERE "language" = 'nl-NL' ORDER BY "id" ASC LIMIT 1)
) LIMIT 1;

v2.1.0 - 2025-05-08

Added

ban-truncate-cascade rule (#453)

v2.0.0 - 2025-05-07

Added

Ignore comments to disable a rule inline.
Fancier lint violation formatting in the terminal using annotate-snippets.
WASM powered playground to run Squawk locally in the browser.
New parser with error recovery -- it doesn't fail if you're missing a comma, semicolon, etc! This also means we've removed the dependency on libpg_query.
Dockerfile to run Squawk in a container (#422). Thanks @alphayax!

Removed

prefer-big-int rule, which has been deprecated in favor of prefer-bigint-over-int and prefer-bigint-over-smallint for a while now.

v1.6.1 - 2025-05-02

Fixed

Fixed panic when formatting violations (#426).

v1.6.0 - 2025-04-02

Added

Added ban-alter-domain-with-add-constraint and ban-create-domain-with-constraint (#418). Thanks @johnmastro!

v1.5.5 - 2025-03-20

Fixed

Fixed adding-not-nullable-field incorrectly failing to check for nulls (#412). Thanks @schew2381!

v1.5.4 - 2025-01-14

Fixed

Fixed building macOS Python wheels for x86 (#406). Thanks @ermakov-oleg!

v1.5.3 - 2025-01-12

Fixed

Bump package version to set latest (#404).

v1.5.2 - 2025-01-11

Fixed

Fixed accidental glibc upgrade (#401).

v1.5.1 - 2025-01-10

Fixed

Fixed support for custom LIBPG_QUERY_PATH (#399).

v1.5.0 - 2025-01-09

Added

Added warning to adding-field-with-default to warn about generated columns (#397).

Fixed

Fixed bug in adding-required-field where generated columns were incorrectly flagged (#397).

v1.4.1 - 2024-10-10

Fixed

fix start transaction support (#386). Thanks @bmbferreira!

v1.4.0 - 2024-09-24

Added

added support for linux arm64 builds (#382).

v1.3.0 - 2024-09-21

Added

Add file violation count to summary report output (#378). Thanks @ermakov-oleg!

v1.2.0 - 2024-09-08

Added

added support windows builds (#368). Thanks @ermakov-oleg!
improved docs for "disallowed-unique-constraint" (#370). Thanks @teeyingyap!

Fixed

fixed "prefer-robust-stmts" to work with RLS (#367)

v1.1.2 - 2024-06-26

Fixed

fix install for darwin-x86 (#361)

v1.1.1 - 2024-06-16

Fixed

fix build for macos arm64 (#356)

v1.1.0 - 2024-06-13

Changed

support configuration for "fail_on_violations" via upload_to_github.fail_on_violations (#353)
support root flags within upload-to-github subcommand (#353)

v1.0.0 - 2024-06-11

Changed

provided paths now support glob matching. squawk 'migrations/*.sql' (#352)

v0.29.0 - 2024-05-30

Added

added --excluded-paths flag and excluded_paths = ["example.sql"] configuration option to ignore paths when searching for files (#350). Thanks @rdaniels6813!

v0.28.0 - 2024-01-12

Changed

add exceptions for ban-concurrent-index-creation-in-transaction to handle golang-migrate. Thanks @janrueth! (#339)
improve disallowed-unique-constraint to handle alter table...add column... unique. (#337)

v0.27.0 - 2024-01-11

Added

added ban-concurrent-index-creation-in-transaction rule. Thanks @alixlahuec! (#335)

v0.26.0 - 2023-12-12

Changed

squawk upload-to-github will always leave a pull request comment if files are evaluated. Previously if violations were resolved, stale warnings would be left in a comment. (#330)

v0.25.0 - 2023-12-09

Added

added squawk upload-to-github --fail-on-violations flag to exit with error if violations are found (#327). Thanks @wmartins!

v0.24.2 - 2023-11-07

Fixed

support parsing alter database refresh collation statements (#324)

v0.24.1 - 2023-10-24

Fixed

support parsing alter table set statements (#321)

v0.24.0 - 2023-04-11

Added

added transaction-nesting rule. Thanks @andrewsmith! (#303)
added adding-required-field rule from adding-not-nullable-field. Thanks @andrewsmith! (#301)

Changed

functionality in adding-not-nullable-field for adding non-nullable fields was moved into adding-required-field. Thanks @andrewsmith! (#301)

v0.23.0 - 2023-03-30

Changed

Only read from stdin when file paths are not provided. (#295)

v0.22.0 - 2023-03-25

Added

added ban-drop-table rule. Thanks @borisrozumnuk! (#286)
added not-null-constraint rule. Thanks @andrewsmith! (#288)

Fixed

Fixed building Squawk on platforms where c_char is unsigned. Thanks @ods! (#285)
Fixed Squawk compatiblity with Nix. Thanks @andrewsmith! (#287)
Fixed regression in parsing union queries. Fixed parsing call statement. (#293)

Changed

Upgrade libpg_query from 13 to 15. Thanks @andrewsmith! (#291)

v0.21.0 - 2023-02-14

Fixed

Better support non-volatile defaults for adding-field-with-default. (#278)
Static link for openssl and glibc. (#283)

v0.20.0 - 2023-01-31

Added

added prefer-bigint-over-int and prefer-bigint-over-smallint to replace prefer-big-int. Thanks @aldenquimby! (#273)

Fixed

Support TableLikeClause in table creation. Thanks @qoelet! (#271)
Recognize most DROP statements within a transaction as robust. Thanks @andrewsmith! (#276)

v0.19.0 - 2023-01-24

Added

added --assume-in-transaction flag and configuration option to indicate that each SQL file is wrapped in a transaction by an external tool. Thanks @andrewsmith! (#264)

v0.18.0 - 2023-01-06

Fixed

error parsing multiple transactions in one file (#259)

v0.17.0 - 2022-07-27

Added

added better error handling of invalid syntax. (#245)

v0.16.0 - 2022-07-22

Added

added prefer-big-int rule to prefer 64 bit types over 32 bit types. (#238)
added prefer-identity rule to prefer identity columns over serial columns. (#243)

v0.15.0 - 2022-07-17

Added

added prefer-timestamptz rule to warn about using timestamp instead of timestamptz. (#230)

Changed

only apply prefer-robust-stmts to files with more than one SQL statement. (#231)

Fixed

catch another way to add foreign keys for adding-foreign-key-constraint. Thanks @adamrdavid! (#228)

v0.14.0 - 2022-07-10

Added

added pg_version configuration option to support ignoring rules by Postgres version. Thanks @adamrdavid! (#219)

v0.13.2 - 2022-06-16

Changed

internal: use rule IDs based on serde annotations of RuleViolationKind. (#218)

v0.13.1 - 2022-06-15

Fixed

fix parsing enum values from configuration file. (#217)

v0.13.0 - 2022-06-06

Added

added validation for configured rules. (#216)

Changed

Change help menu value names. (#216)

v0.12.0 - 2022-05-27

Added

added configuration file (.squawk.toml) to specify excluded rules. (#213)

v0.11.3 - 2022-05-11

Fixed

incorrectly silenced stdin

v0.11.2 - 2022-05-11

Fixed

silence stdin if it's empty (#210)

v0.11.1 - 2022-05-11

Fixed

duplicate messages being written when using GitHub Actions token authentication. (#209)

v0.11.0 - 2022-05-11

Added

Support GitHub API authentication via GitHub Actions tokens. (#207)

v0.10.0 - 2022-04-25

Changed

differentiate between VOLATILE and non-VOLATILE defaults in adding-field-with-default documentation (#201)

v0.9.0 - 2022-02-26

Added

require-concurrent-index-deletion rule and removed deletion warnings from require-concurrency-index-creation. Thanks @K-Phoen! (#177)

v0.8.2 - 2022-01-07

Fixed

errors parsing PG12 and later query syntax by upgrading to PG13 parser (#174)
parsing alter constraint statement (#173)

v0.8.1 - 2021-11-30

Fixed

copy pasta of rename-table into the ban-drop-column rule (#168)
parsing an index without a name specified (#169)

v0.8.0 - 2021-10-31

Fixed

false positives with disallowed-unique-constraint and adding-serial-primary-key-field. Thanks @qoelet! (#161)

v0.7.3 - 2021-08-11

Fixed

false positives with require-concurrent-index rule (#157)

v0.7.2 - 2021-08-02

Fixed

incorrect internal schema for "alter table" statements with function calls. Thanks @qoelet! (#154)

v0.7.1 - 2021-05-30

Fixed

incorrect internal schema for "create partition" statements. (#146)
upload-to-github command not obeying top level --excludes. (#142)

Changed

allowing adding not null column with default for adding-not-null-field. (#144)

v0.7.0 - 2021-05-19

Added

link to website for tty reporter when there are lint errors. (#120)
DROP INDEX support for "require-concurrent-index-creation" and "prefer-robust-stmts". (#124)
github comment now includes Squawk's version number. (#131)
new ban-drop-column rule (#132)

Changed

updated "adding-not-null-field" to warn about making a column non-nullable with NOT NULL. See the "adding-not-null-field" docs for more information. (#101)

Fixed

false positive with prefer-text-field that wasn't allowing varchar without a length specified

v0.6.0 - 2021-02-19

Added

added "debug" option for --dump-ast to print out tree using Rust's Debug formatter (#92)
added new rule, "adding-foreign-key-constraint", to provide suggestions for safely adding foreign key constraints (#91)

Changed

updated "robust-stmts" suggestions with caveat about IF NOT EXISTS (#95)
updated "constraint-missing-not-valid" to warn about adding a constraint as NOT VALID and then using "VALIDATE CONSTRAINT" in the same transaction (#97)
updated "prefer-robust-stmts" with exception for using DROP CONSTRAINT IF EXISTS before ADD CONSTRAINT (#99)

Fixed

error reporting is more user friendly (#89, #90)

v0.5.4 - 2021-01-08

Fixed

parsing of RangeVar with missing inh field

v0.5.3 - 2021-01-04

Fixed

parsing of alter table with type cast

v0.5.2 - 2020-10-26

Fixed

parsing of create table with primary key constraint on two fields

v0.5.1 - 2020-10-07

Fixed

run prefer-text-field on alter table statments

v0.5.0 - 2020-09-08

Added

new rule adding-primary-key-field

Fixed

parsing ->> operator

v0.4.1 - 2020-08-19

Fixed

parse function calls in alter table statements

v0.4.0 - 2020-07-19

Added

new rule ban-char-type

v0.3.0 - 2020-07-10

Changed

upload-to-github comment formatting to hopefully be more clear
docs on crates.io for sub crates

v0.2.3 - 2020-07-09

Added

new rule prefer-robust-stmts

v0.2.2 - 2020-06-25

Fixed

upload-to-github commenting on PRs when no files provided (#30)

v0.2.1 - 2020-06-25

Changed

remove SQUAWK_GITHUB_BOT_NAME env var for github upload, no longer needed (#27)

Fixed

false positive in unique constraint rule (#28)

v0.2.0 - 2020-06-23

Added

logging, mainly around upload-to-github (#24)
--stdin-filepath argument (#23)
output a success message for CLI tty reporter (#22)

Changed

prefix env vars with SQUAWK_ (#21)

Fixed

error level HTTP status codes not being errors (#20)

v0.1.4 - 2020-06-21

Added

upload-to-github subcommand for outputing squawk results in a GitHub PR comment.
print help menu when no options provided
automatically detect stdin instead of using the - path

Fixed

off by one error in slicing problem SQL for the tty reporter

v0.1.3 - 2020-06-12

Added

documentation for rules
release binaries
CI

v0.1.0 - 2020-06-05

Added

Initial release

FilesExpand file tree

CHANGELOG.md

Latest commit

History

CHANGELOG.md

File metadata and controls

Changelog

[Unreleased]

v2.48.0 - 2026-04-18

Added

Fixed

v2.47.0 - 2026-04-13

Added

v2.46.0 - 2026-04-05

Added

Fixed

v2.45.0 - 2026-04-01

Added

Internal

v2.44.0 - 2026-03-19

Added

Fixed

Changed

Internal

v2.43.0 - 2026-02-28

Added

Fixed

Internal

v2.42.0 - 2026-02-25

Changed

Added

Fixed

v2.41.0 - 2026-02-20

Added

Fixed

Changed

v2.40.1 - 2026-02-12

Fixed

Added

v2.40.0 - 2026-02-06

Added

Fixed

v2.39.0 - 2026-01-31

Added

Changed

Fixed

v2.38.0 - 2026-01-24

Added

Changed

Fixed

v2.37.0 - 2026-01-18

Added

Changed

Fixed

v2.36.0 - 2026-01-06

Added

Fixed

v2.35.0 - 2026-01-02

Added

Fixed

v2.34.0 - 2025-12-22

Added

Internal

v2.33.2 - 2025-12-16

Fixed

v2.33.1 - 2025-12-16

Fixed

v2.33.0 - 2025-12-16

Added

Fixed

v2.32.0 - 2025-12-04

Fixed

Added

v2.31.0 - 2025-11-24

Added

Fixed

v2.30.0 - 2025-10-30

Added

v2.29.0 - 2025-10-19

Added