sql: support in-memory SQL arrays of JSON

Exalate commented:


https://github.com/cockroachdb/cockroach/pull/70041 --- Release note (sql change): add support for SQL arrays containing JSON for in-memory processing. This does not add support for storing SQL arrays of JSON in tables.

Jira Issue: DOC-1726