News for hackers. Stuff that matters.
Re:Relational is more than SQL by ttfkam on Monday September 18, 2023 @08:00PM (#37563918)
How would LINQ make jsonpath queries or unroll arrays on the database with unnest?
Re:Relational is more than SQL by naasking on Tuesday September 19, 2023 @10:49AM (#37570730)
LINQ in EntityFramework (EF) supports querying JSON columns as objects [1].

unnest support is potentially on the horizon for EF core for PG [2], but already supported for Couchbase [3].

[1] https://learn.microsoft.com/en-ca/ef/core/what-is-new/ef-cor...

[2] https://github.com/npgsql/efcore.pg/issues/1525

[3] https://github.com/couchbaselabs/Linq2Couchbase/blob/master/...