That is, not by calling the psql or sqlcmd commands, but by passing the script file or its contents to a library function that connects to Postgres or SQL server? Maybe Psycopg (for Postgres), since we're already importing that. The advantage would be that the user wouldn't need to have the relevant bin directories in their PATH. The disadvantage might be that it's just to much hassle to make it work.
Can we run the SQL scripts directly from Python?
That is, not by calling the
psqlorsqlcmdcommands, but by passing the script file or its contents to a library function that connects to Postgres or SQL server? Maybe Psycopg (for Postgres), since we're already importing that. The advantage would be that the user wouldn't need to have the relevantbindirectories in theirPATH. The disadvantage might be that it's just to much hassle to make it work.