I also do recall hearing something about sqlite supporting lateral joins at some point?
I just saw that turso might be getting lateral joins soon: https://github.com/tursodatabase/turso/pull/4462
Maybe in the future sqlite will be replaced by turso, as it might just become a better sqlite. “Extended ALTER support” and “improved write throughput using MVCC” sounds awesome to me.
