Tweak queries to recurse properly and optimize for clarity/efficiency
Expand authorization.role unit tests and remove crufty code
Detect unrooted roles
Write more idiomatic queries (map form, appropriate find bindings, etc)
fixup! 679a802b1dbc1e7a23f4e56f6c4e8f6ed710eb62
Write more idiomatic transactions and delegate exception handling to db