json_value

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.40.0a⚠ 2016 - 2022bc⊘ 2008R2 - 2014⊘ 8.3 - 15⚠ 12cR1 - 21cb⊘ 11gR1 - 11gR2⚠ 8.0.21 - 8.0.31b⊘ 5.0 - 8.0.20⚠ 10.2 - 10.10b⊘ 5.1 - 10.1⚠ 11.5.0 - 11.5.7b⊘ 9.7 - 11.1⚠ 2.0bc
  1. See JSON1 extension
  2. Returning clause with limited functinality
  3. Defaults to error on error