Article Dan Pasco · Feb 22 4m read IRIS 2024.1 Preview - New Feature There is an interesting new feature in the recently announced 2024.1 preview, JSON_TABLE. JSON_TABLE is one of a family of functions introduced by the 2016 version of the SQL Standard (ISO Standard, published in early 2017). It allows for JSON values to be mapped to columns and queried using SQL. JSON_TABLE is valid in the FROM clause of some SQL statements. The syntax of JSON_TABLE is quite large, allowing for exceptional conditions where the provided JSON values don't match expectations, nested structures and so on. #JSON #SQL #InterSystems IRIS 10 4 3 422
Article Dan Pasco · Jan 19 4m read Querying Dynamic Data using ASQ IRIS 2023.3.0 ASQ Abstract Set Query, ASQ, is a super set of JSON Path Language, JPL, which was first introduced by the 2016 ISO SQL Standard. JPL is only defined within the context of SQL. In 2023.3, we introduced classes that implement ASQ. It works on any implementation of %Library.AbstractSet. The complete syntax for ASQ will be documented later. This is just a quick introduction to a few of its features. This implementation comes with a nice utility as well. You will know it when you see it! #InterSystems IRIS 9 14 1 402
Article Dan Pasco · Nov 28, 2023 18m read Maven Projects - Mixing Java and ObjectScript Maven Projects mixing ObjectScript and Java What is Maven? Maven is a tool, hosted by the Apache Software Foundation, for building and managing any Java-based project. Apache Maven is the best source of information. #Java #Languages #ObjectScript #InterSystems IRIS 2 0 2 232