Add JSON structure to where clause.

[josephmancuso]

Describe the feature as you'd like to see it We should be able to query JSON column data.

i think we can use the arrow -> here to compile something like.

# Masonite
ModelName.select("meta->active", 1).get()

# MySQL
SELECT json_column->'field_name' FROM your_table;

Postgres is similar

# Postgres
SELECT json_column->'field_name' FROM your_table;

SQLite is a little different

# SQLite
SELECT json_extract(column_name, '$.field_name') FROM your_table;

What do we currently have to do now? dont have anything

Additional context https://laravel.com/docs/10.x/queries#json-where-clauses

• [ ] Is this a breaking change?