Use same client from chained database queries

[nigelmpofu]

Use pool.connect() for some chained database queries to improve performance by using the same client for all the queries within a transaction. This has the added benefit of reducing the number of connections required to perform certain queries.