Postres has had this for years. It's arrows instead of dots, but that's the only visual difference.

It's not the same at all, and it gets much more verbose with minor complexity and lacks functionality.

PG is working on adding SQL/JSON support for JSON Path queries for the next version. It'll be a major improvement but still not as nice as what PartiQL has here.

The SQL standard includes JSON support: https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016

The SQL standard is different from what databases actually support. No RDBMS supports this yet. Only Elasticsearch, Couchbase, and managed services like Rockset and CosmosDB.

Oracle 12.2+ reportedly supports the ISO SQL/JSON though I haven't tried it. Which btw looks like mostly just renames of Postgres functions.

https://docs.oracle.com/en/database/oracle/oracle-database/1...