Can my DB?

JSON Support

JSON storage, querying, path expressions, aggregation, and indexing.

0 features
but not in
JSON Aggregation
Aggregate multiple rows into a JSON array or object using aggregate functions.
JSON_AGGJSON_ARRAYAGGJSON_OBJECTAGGJSON_OBJECT_AGGARRAY_AGGOBJECT_AGG
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
JSON Path Queries
Extract and query values from JSON documents using path expressions.
json pathjson extractjson queryjson arrow operator
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
JSON Path Update
Update, set, insert, or remove specific values within a stored JSON document using path expressions.
jsonb_setJSON_SETJSON_REPLACEJSON_MODIFYJSON_REMOVEJSON_INSERTJSON_MERGEPATCHJSON_TRANSFORM
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
JSON_TABLE
Shred a JSON document into relational rows and columns using a declarative SQL function.
JSON_TABLEjson_to_recordsetFLATTENOPENJSONJSON_EACHjson_array_elements
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
JSON Data Type
Native column type for storing JSON documents.
json columnjsonbjson storage
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery