Prepare tests to cover missing SQLiteQueryExecutor queries

Summary: I created it in order to provide unit tests that can serve as a test plan for previous differentials in this stack since most of them break the app.

Test Plan: Execute implemented tests.

Reviewers: kamil, michal

Reviewed By: kamil

Subscribers: ashoat, tomek

Differential Revision: https://phab.comm.dev/D10711