New test for query builder

[winder]

Subject of the issue

To compensate for a lack of query performance tests, we can at least test that queries are generated consistently. Especially for specific performance-related items.

In this issue, we should add a test to ensure the root transaction join clause is created correctly. This bit us recently when the small change was lost during a merge conflict.

Acceptance Criteria

A new test is created that generates a transaction search query. Ensure the correct root-intra parameters are used: (t.extra->>'root-intra')::int = root.intra.