Rewrite postgres querybuilder w/ Slonik #2
Description
After discovering slonik-tools and additional type-gen tooling, the querybuilder can be rewritten to incorporate better compile-time checking based on the same postgres tagged-template API as before.
Some issues to address is flattening CTE optimization fences that nesting multiple CTEs creates to allow the query planner to better understand the intent of the query. With the current queries written, this will allow static subqueries to be written more efficiently and avoid fetching additional data from any database table.