T821, "Basic SQL/JSON query operators"

1. See Alternatives
2. Accepts unquoted object keys: {a: 1} • No type constraints: ... is json (削除) [array|object|scalar] (削除ここまで)

Related

• Primer: "JSON Path"

• Other SQL/JSON path array accessors:

  • Last element: [last]

  • Ranges: [... to ...]

Normative References

T821, "Basic SQL/JSON query operators", is an optional feature of ISO/IEC 9075-2. It first appeared in the 2016 revision.

You can’t catch up on 20 years of SQL evolution in one day. Subscribe the newsletter via E-Mail , Bluesky or RSS to gradually catch up and to keep modern-⁠sql.com on your radar.

About the Author

Can I use...

News

The Standard

Concepts

Features

Use Cases