How to have JSON subquery return empty array rather than null when there are no rows
I have a (hypothetical) JSON schema that calls for a document to look like: [ { "tableName": "Embeddings", "object_id": 1301579675, "type_desc": "USER_TABLE", "create_date": "2023-05-03T19:41:56.940", "indexes": [ { "name": "PK_Embeddings", "type_desc": "CLUSTERED", "is_unique": true, "is_primary_key": true }, { "name": "IX_Embeddings_DimValue", "type_desc":…