json_table

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.40.0⊘ 2016 - 2022b⊘ 2008R2 - 2014⊘ 8.3 - 15✓ 12cR1+a⊘ 11gR1 - 11gR2✓ 8.0.11+a⊘ 5.0 - 5.7✓ 10.6+a⊘ 5.1 - 10.5⊘ 9.7 - 11.5.7⊘ 2.0
  1. Without plan clause
  2. Use OPENJSON