It has it, but the syntax is different: SELECT t->'j'->'foo'->'bar'->2, ... FROM... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		pdw on April 14, 2023 \| parent \| context \| favorite \| on: SQL:2023 is finished: Here is what's new It has it, but the syntax is different: `SELECT t->'j'->'foo'->'bar'->2, ... FROM tbl t ...` I think SQLite now also supports this syntax.

masklinn on April 14, 2023 [–]

I would not call “has similar features with a completely incompatible syntax” “having it”.

After all if that’s your benchmark every database with a TEXT type already has T081.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact