JSON path: array accessor .[…]

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⚠ 3.9.1 - 3.40.0abdef⚠ 2016 - 2022abdef✓ 12+⚠ 21cbc⚠ 12cR1 - 19cabc⚠ 8.0.11 - 8.0.31bd⚠ 5.7abde⚠ 10.9.2 - 10.10bd⚠ 10.2 - 10.8abde⚠ 11.5.0 - 11.5.7abde⚠ 2.0abd
  1. No expressions
  2. No last
  3. Multiple subscripts: only ascending (not $[1,0]), removes duplicates ($[0,0])
  4. No ranges ([… to …])
  5. No multiple subscripts (T833)
  6. No wildcard ($[*])