QA: Support TSQuery operators @>, <@, &&, ||, !! and <->

From [TSVector and TSQuery QA](https://gist.github.com/msirek/2c4aef2a3c2038f6b9f3a6fa443ad6da),

These examples from Postgres docs return "unsupported comparison operator" or "unsupported binary operator" or syntax error in CRDB:
```sql
SELECT 'fat | rat'::tsquery && 'cat'::tsquery;
SELECT 'fat | rat'::tsquery || 'cat'::tsquery;
SELECT 'cat'::tsquery @> 'cat & rat'::tsquery;
SELECT 'cat'::tsquery <@ 'cat & rat'::tsquery;
SELECT 'cat'::tsquery <@ '!cat & rat'::tsquery;
SELECT !! 'cat'::tsquery;
SELECT to_tsquery('fat') <-> to_tsquery('rat');
```
This issue is opened to add support for these operators.

Jira issue: CRDB-25466