sql: support inverted join for tsvector / tsquery

**Is your feature request related to a problem? Please describe.**
We currently cannot index-accelerate queries with `@@` predicates when both sides of the operator are variables. For example,
```
SELECT col1, col2, ts_rank(document, query) AS rank
FROM tablename@tablename_expr_idx, to_tsvector(col1 || col2) document, plainto_tsquery('text') query
WHERE query @@ document
ORDER BY rank DESC
LIMIT 10
```
returns the error
```
ERROR: index "tablename_expr_idx" is inverted and cannot be used for this query
```
where `tablename_expr_idx` is defined as:
```
CREATE INDEX ON tablename USING GIN (to_tsvector('english', col1 || col2));
```

**Describe the solution you'd like**
We should add support for inverted join with tsvector / tsquery types so that we can index-accelerate queries like the one above.

Jira issue: CRDB-27620

Start by reproducing the SQL example with the GIN expression index and confirm the current inverted-index error for the query @@ document form. Trace how tsvector and tsquery predicates are handled for inverted joins; done means the query can use the index without that error and has regression coverage.

Written by the indexing model from the issue text.