How to access grammar from query builder?

Question

I'm trying to convert a json column name with path 'foo->bar' to be compatible with mysql/postgresql using Laravel's wrapJsonSelector() method.

How can I access this method from the query builder calling getGrammar throws error:

Method Illuminate\Database\Query\Grammars\MySqlGrammar::isJsonSelector does not exist.

Eg

$query->where(function (Builder $query) use ($searchColumn): Builder {
    if ($query->getGrammar()->isJsonSelector($searchColumn)) {
        $searchColumn = $query->getGrammar()->wrapJsonSelector($searchColumn);
    }
    // ...
})

Answer 1

isJsonSelector and wrapJsonSelector are protected methods, which means you cannot access them from outside the class. However, you don’t need to invoke either of them directly in the first place. You can just use the wrap method, which will invoke wrapJsonSelector in the case you want to cover here.

Answer 2

DB::table('your_table')
->selectRaw('your_json_column->"$.foo->bar" as modified_column')
->get();

The selectRaw method allows you to write raw SQL expressions within your query.

Answer 3

The wrapJsonSelector method is not accessible (protected), but it is called in the wrap method.

$expression = $query->getGrammar()->wrap("table.column->?"); // "table"."column"->>'?'
$query->whereRaw($expression, ['value']);