Consider using new psycopg2 features

[marcmengel]

In particular:
https://www.psycopg.org/docs/extras.html#fast-execution-helpers

instead of executemany(), to speed up bulk metadata additions, etc.

[marcmengel]

In fact, we should probably consider migrating to psycopg (implied 3).