JSON path: item methods .…()

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.9.1 - 3.40.0⊘ 2016 - 2022✓ 13+a⚠ 12a⚠ 21ce⚠ 19ccde⚠ 18ca⚠ 12cR2ab⊘ 12cR1⊘ 5.7 - 8.0.31⊘ 10.2 - 10.10⊘ 11.5.0 - 11.5.7⊘ 2.0
  1. No .datetime()
  2. No .keyvalue()
  3. No .datetime() (but .date() and .timestamp())
  4. Only in ?(…): abs, ceiling, floor, double
  5. .size() returns the number of keys in objects