Announcing sql_insert_writer, a Python3 utility to build skeletons for INSERT and INSERT FROM statements, with explicit target column lists and clarifying comments.
https://github.com/18F/sql_insert_writer Usage example (assumes that the `pip` package manager has been installed, and a local database `zoo` with tables `pet`, `animal`) $ pip install sql-insert-writer psycopg2 $ export DATABASE_URL=postgresql:///zoo $ sql_insert_writer pet INSERT INTO pet ( id, name, species_name, planet, kg ) VALUES ( DEFAULT, -- ==> id DEFAULT, -- ==> name DEFAULT, -- ==> species_name DEFAULT, -- ==> planet DEFAULT -- ==> kg ) $ sql_insert_writer pet animal INSERT INTO pet ( id, name, species_name, planet, kg ) SELECT id, -- ==> id name, -- ==> name species_name, -- ==> species_name planet, -- ==> planet DEFAULT -- ==> kg FROM animal -- - Catherine @ 18F https://18f.gsa.gov/
