SQLite also supports referencing by parameter number (and name):

https://www.sqlite.org/lang_expr.html#varparam

So, changing "?" to "?1" could be done in SQLite before the actual migration, leaving just the change from ? to $ when migrating to Postgres.