PP-287 test method and limits | checked 2026-10-03 UTC Historical record: this describes an earlier hands-on check run on October 3, 2026, before Practical Picks adopted its research-only method. It is kept unchanged below as dated evidence. We no longer run product checks; the current article was re-decided on October 20, 2026 from public sources, and these observations corroborate it but did not decide it. Versions checked: SQLFluff 4.4.0, Sqruff 0.40.0. The Prettier SQL-CST plugin, added on October 20, 2026, was not part of this check. Job: check a small SQLite migration SQL text file before execution. This is not a database migration test or a guarantee of valid SQL. No real database, account, vendor cloud service, or system package install was used. The only SQLite execution was in Python's disposable in-memory database for semantic checks. Download the eight linked files, keeping fixtures/ alongside replay.py: /assets/pp287/acquire.sh ; /assets/pp287/replay.py ; /assets/pp287/replay-results.json ; /assets/pp287/fixtures/valid.sql ; /assets/pp287/fixtures/malformed.sql ; /assets/pp287/fixtures/challenge.sql ; /assets/pp287/fixtures/comment-edge.sql ; /assets/pp287/fixtures/transaction.sql . The scripts and fixture bytes match the research record; replay.py checks each fixture SHA-256 before testing. Prerequisites: Linux x86-64, Python 3 with venv and pip support, curl, tar and sha256sum. Use a fresh task-local directory. From the downloaded directory: bash acquire.sh "$PWD/pp287-tools" python3 replay.py "$PWD/pp287-tools/venv/bin/sqlfluff" "$PWD/pp287-tools/sqruff" "$PWD/pp287-replay-results.json" acquire.sh installs SQLFluff 4.4.0 and dependencies in its own Python venv. It downloads Sqruff v0.40.0 from the official GitHub release URL https://github.com/quarylabs/sqruff/releases/download/v0.40.0/sqruff-linux-x86_64-musl.tar.gz plus that release's .sha256 sidecar. It verifies both the publisher sidecar and our recorded SHA-256 8a377bdfdfaf46483c33cce46d3b4eb46bcec4b9557f6d0106adc85cc926660e before extraction. The fresh task-local tree used 76 MB here. PyPI dependencies are resolved at install time; pin or lock them for a long-lived team workflow. Delete the task-local directory to remove these test tools. replay.py uses separate temporary copies. Its exact command forms are: sqlfluff lint|fix --dialect sqlite --library-path none FILE sqruff --dialect sqlite --library-path none --parsing-errors lint|fix FILE It records every argv, stdout, stderr and exit in JSON. Both tools first report style violations, then fix the valid script. A second fix is byte-identical; lint returns 0. Both reject the malformed missing-bracket script with nonzero exit, and fix leaves it unchanged. The simple formatted output SHA-256 for each is 3088e993e128727f3fca746754cda7f5654fe5df83d85f6263cafc0a427d2166. In-memory SQLite checks table columns/default, primary key, index and one invented row before and after formatting. An expanded partial-index/view/update script also ran in memory before and after formatting. The CASE comment edge is important: SQLFluff's default fix removed `/* keep default */` with an `ELSE NULL` branch, while Sqruff's default fix retained it. SQLFluff's `--rules core` retained that comment in a separate targeted check; the published replay records default behavior. See SQLFluff issue #8562: https://github.com/sqlfluff/sqlfluff/issues/8562 . Always inspect a formatting diff before using it. The valid transaction.sql fixture contains BEGIN IMMEDIATE, STRICT table creation, an index, and COMMIT. Python SQLite executed it in memory, but both linters returned nonzero parse diagnostics. A nonzero lint result can therefore be a parser false positive. Neither product proves that SQL will apply safely to a particular database, preserve data, or suit a deployment. We did not test a real database, migration runner, trigger, large file, concurrent changes, other operating systems, or all SQLite syntax. Recheck versions and advisories before use. Source versions: SQLFluff https://github.com/sqlfluff/sqlfluff/releases/tag/4.4.0 ; Sqruff https://github.com/quarylabs/sqruff/releases/tag/v0.40.0 . Both tested local CLI paths cost $0 and required no account on this date. License: SQLFluff MIT; Sqruff Apache-2.0. No vendor access or payment influenced this comparison.