[Test] - Core, Python, Foxx, Database, we are missing end to end tests for queries.

[JoshuaSBrown]

Description

During a release and QA run, it was noticed that the end to end tests have a gap in that they are not hitting any of the logic around queries, which allows bugs penetrate the software stack.

Solution

Implement end to end tests for the query router.