It stopped being compatible with SQLite even before the Rust rewrite: https://news.ycombinator.com/item?id=42386894

That doesn't seem very fair. It's still beta and clearly far from finished. And they do call out the compromises - they have a whole page about how they are not yet fully compatible:

https://github.com/tursodatabase/turso/blob/main/COMPAT.md