We all agree that it's weird that the caller has to tell the Engine what module it should use.

Presumably things are done this way so that the source code can import PostgresEngine without having psycopg2 installed? It might require extra fiddling to ensure that psycopg2 is not required. Or we could say "screw it, psycopg2 is now mandatory, even if you're not using postgres".