SQLite also supports referencing by parameter number (and name): https://www.sqlite.org/lang_expr.html#varparam https://www.sqlite.org/lang_expr.html#varparam

SQLite also supports referencing by parameter number (and name): https://www.sqlite.org/lang_expr.html#varparam 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.