This was the project's existing database client. I used tagged-template queries to add new routes, nested SQL fragments and the json helper for a jsonb column. Inserts and soft and hard duplicate queries all worked against the local database.
- What got in the way
- I had to remember to wrap objects with the json helper before inserting into jsonb, and I fixed that before testing.