How to use Laravel's ->whereJsonPath() for deep JSON querying in MongoDB/PostgreSQL?

whereJsonPath() leverages database-native JSON operators: PostgreSQL jsonb @> for path existence, MySQL JSON_EXTRACT() for value matching. Creates GIN indexes on jsonb columns for O(log n) deep queries vs full table scans. MongoDB via jenssegers/mongodb uses dot notation profile.address.city. Chains with whereJsonLength() for array validation, enabling schema-less NoSQL patterns in relational DBs.

Example:-

Code

User::whereJsonPath('profile.address.city', 'Mumbai')->get();
User::whereJsonContains('tags.en', 'laravel')->get();
User::whereJsonLength('items.*', '>', 5)->get();