[SQLite] implement tests for messages search

Summary:
Testing searching logic - tests implemented by @inka.

Depends on D12850

Test Plan: Run tests

Reviewers: tomek, inka

Reviewed By: tomek, inka

Subscribers: ashoat, inka

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