5 ms·
This is pretty nice. If only because using a SQL dotted syntax seamlessly with JSON data.
by manigandham 7y ago
This is pretty nice. If only because using a SQL dotted syntax seamlessly with JSON data.
- smt88 7y agoPostres has had this for years. It's arrows instead of dots, but that's the only visual difference.
- manigandham 7y agoIt'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.
- dangoor 7y agoThe SQL standard includes JSON support: https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016 https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016
- manigandham 7y agoThe SQL standard is different from what databases actually support. No RDBMS supports this yet. Only Elasticsearch, Couchbase, and managed services like Rockset and CosmosDB.
- deleted 7y ago[deleted]
- sixbrx 7y agoOracle 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/12.2/adjsn/toc.htm https://docs.oracle.com/en/database/oracle/oracle-database/1...