Can you elaborate on both of these issues? Vanilla SQLite solved multiple writers a long time ago when they introduced WAL in 2010. Does Turso not support this

Can you elaborate on both of these issues? Vanilla SQLite solved multiple writers a long time ago when they introduced WAL in 2010. Does Turso not support this? Is the issue with foreign keys that they're not enabled by default?