[Postgres] Add “none” Full-Text Mode (raw to_tsquery) to allow prefix/custom operators

[opheus2]

Feature Request: Add mode = none to whereFullText() for raw to_tsquery for Postgres

Hi! 👋

I’d like to propose adding support for a “none” mode to the full-text query grammar so that whereFullText() can optionally use raw to_tsquery instead of plainto_tsquery, phraseto_tsquery, or websearch_to_tsquery.

Why this is needed

PostgreSQL’s prefix search (:*) is not recognized by:

• plainto_tsquery
• phraseto_tsquery
• websearch_to_tsquery

These functions all treat characters like : and * as literal text, not operators.
This means you cannot perform a prefix search like:

to_tsquery('english', 'Ent:*')

when using the current whereFullText() implementation.

Prefix searching is a very common use case (autocomplete, partial-name search, etc.), and the only way to get it is via the raw to_tsquery function.

Proposed Enhancement

allow:

['mode' => 'none']

to select:

$mode = 'to_tsquery';

Example Usage

$q->whereFullText('full_name', "{$prefix}:*", [
    'mode' => 'none',
]);

Which would compile to:

to_tsvector('english', full_name) @@ to_tsquery('english', 'Ent:*')

This gives developers a clean and safe way to use native tsquery syntax—especially prefix operators—without manually writing raw SQL.

PR

#57915

Similar changes elsewhere
tpetry/laravel-postgresql-enhanced#121

---