The 10.6.0 release of MariaDB has added a JSON_TABLE() function.

The JSON_TABLE() function returns a representation of a JSON document as a relational table with the specified columns. It enables you to map JSON paths into relational columns to be returned in its results set.

At the time of this writing, MariaDB 10.6.0 is an Alpha release.

The JSON_TABLE() function was initially requested in the JIRA tool in 2018, and was closed (as fixed) yesterday. JIRA is the tool that tracks bugs and feature requests in MariaDB.

The JSON_TABLE() function was added to the MariaDB documentation earlier today.