sql_insert_writer v0.1.0

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/