As it stands, we just use this make target, which works well enough:

# Only lint migrations after 172, since we can't change old ones, and
# 172-forward lint without errors currently.
LINTED_MIGRATIONS := $(shell fd . 'data/db/proxy/migrations' \
								--extension sql \
								--max-depth 1 \
								--format {/} \
								--exec bash -c '[[ "{/}" > "0172" ]] && echo {}')
# Lint db migrations. Note that the DB must be running for this check.
db-lint: .make/db-lint
.PHONY: db-lint
.make/db-lint: $(LINTED_MIGRATIONS) | .make
	if [[ "$?" ]]; then
		postgrestools check $?
	fi
	touch .make/db-lint

Thanks for the feedback! Did you see this part in the docs?

For pre-commit hooks and when working locally, use --staged to only lint files that have been staged. In CI environments, you most likely want to use --changed to only lint files that have been changed compared to your vcs.defaultBranch configuration. If defaultBranch is not set in your postgrestools.jsonc, use --since=REF to specify the base branch to compare against.

Stil, I will test this on the weekend, because I am quite sure we don't care about timestamps and simply parse the number. So maybe there is just a bug here and your case should work.