[feature]: Migration of Payment KV to SQL

[ziggie1984]

related PR:

• payments: kv-to-sql migration (tests + wiring) #10485
• Add GPRC methods for the duplicate payments table for the SQL backend #10489
• tbd (maybe another PR which makes the migration from pg more efficient