Буду очень благодарен
vals = [(f'username{i}', "val", "val") for i in range(10)]
vals
Out[13]:
[('username0', 'val', 'val'),
('username1', 'val', 'val'),
('username2', 'val', 'val'),
('username3', 'val', 'val'),
('username4', 'val', 'val'),
('username5', 'val', 'val'),
('username6', 'val', 'val'),
('username7', 'val', 'val'),
('username8', 'val', 'val'),
('username9', 'val', 'val')]
cur.executemany("insert into table (f, f1, f2) values(%s, %s, %s,)", vals)