MySQL 9.4.0 and later supports JSON duality views. Also known as a JSON relational duality views, these objects are stored queries that when invoked produce a set of values in JSON format. In effect, a JSON duality view acts as a virtual JSON document, or as a collection of virtual JSON documents.

The discussion in the next few sections describes the syntax for creating, altering, and dropping JSON duality views, shows some examples of how to use them, and provides information about obtaining related metadata.

MySQL Enterprise Edition supports updatable JSON duality views. See Section 27.7.2, “Updatable JSON Duality Views (MySQL Enterprise Edition)”, for more information.