News for hackers. Stuff that matters.

A comment on SQLite now allows multiple recursive SELECT statements in a single recursive CTE.

Re:SQLite now allows multiple recursive SELECT statements in... by hehetrthrthrjn on Tuesday October 20, 2020 @10:54PM (#24844345)
If I'm not mistaken, this brings SQLite up to parity with Datalog.
[ Parent | on HN ]
Re:SQLite now allows multiple recursive SELECT statements in... by lactobacillis on Tuesday October 20, 2020 @11:54PM (#24844611)
Can you please expand on this. Thanks
[ Parent | on HN ]
Re:SQLite now allows multiple recursive SELECT statements in... by slifin on Wednesday October 21, 2020 @05:00AM (#24846010)
Unless you're using Clojure engines with Datomic pull syntax, SQL engines (most? all?) can't pull out nested results without serialization nastiness
[ Parent | on HN ]