Possible issue with checks on Postgres

[jpruliere]

Environment

Knex version: 2.4.2
Database + version: PostgreSQL 13.5
OS: Docker container postgis/postgis:latest

Bug

I am writing a migration script to add a constraint on an int column that should only accept multiples of 5 starting with 2020. I expected the check constraint to be created, but an error occured.

// inside a migration script
await knex.schema.alterTable('some_table', (t) => {
	t.check('(?? - 2020) % 5 = 0', ['horizon'], 'some_constraint_name')
})

The error :

alter table "some_table" add constraint some_constraint_name check(($1$2 - 2020) % 5 = 0) - syntax error at or near "$2"

The ?? seem to be taken separately.

I found a temporary workaround that I explained here