News for hackers. Stuff that matters.
Re:Show HN: Querying JSON documents using SQL-like language ... by dig1 on Tuesday February 25, 2020 @07:11PM (#22418969)
Apache Drill [1] is alternative, using ANSI SQL. Beside json, it support JDBC, csv, parquet, file system traversal, HBase, Mongo, S3... I believe it also support joins across different sources, although I haven't tried that.

EDIT: to add context to the story - Apache Drill is running on JVM and can be embedded, so it can be run from Scala code as well.

[1] https://drill.apache.org/docs/querying-json-files/

Re:Show HN: Querying JSON documents using SQL-like language ... by mmalek06 on Wednesday February 26, 2020 @05:27AM (#22421849)
That looks nice. Can it be used in a program? I mean, not from cli, but inside code?