Probably for a query that your application runs occasionally, in-memory processing of JSON data might still be an option. In general, though, querying through JSON-dedicated functions and letting SQL ...

MySQL: REGEXP operator, JSON functions, case-insensitive handling; SQL Server: Pattern approximation, OPENJSON for arrays; SQLite: Progressive fallback (LIKE → GLOB → REGEXP), JSON1 support; 🐛 GitHub ...

WAF vendors overlooked JSON in SQL. Starting around 10 years ago, database engines started to add support for working with JSON (JavaScript Object Notation) data.

Modern database engines today support JSON syntax by default, basic searches and modifications, as well as a range of JSON functions and operators. While JSON support is the norm among database ...

Haas implemented a core JSON type that does basic validation. Dunstan expanded on that by implementing query_to_json , record_to_json , and array_to_json functions that can be used in SQL queries ...

Probably for a query that your application runs occasionally, in-memory processing of JSON data might still be an option. In general, though, querying through JSON-dedicated functions and letting SQL ...