abstract pg client acquisition. simplify and document insertion.  write queries and implementation scaffolding for discrepancies.