syntaqlite 0.6: SQLite dot commands and pyodide

Since my original launch post for syntaqlite, I’ve been quietly working away on it in the background. A lot of the work has been fixing correctness bugs which I discovered as I integrated it into production as the parser for PerfettoSQL in the Perfetto trace processor: as I wrote previously, this has been my dream for over 8 years so it’s amazing to see it finally realized. Just today, I released syntaqlite 0.6, the most interesting release since the original launch, so I wanted to talk about what’s new. The biggest step forward for real world applicability is that we now support SQLite dot commands: .print 'running foo now'; .read foo.sql; .print 'running bar now'; .read bar.sql; select * from baz; -- ^ baz will error if it's not part of the schema! SQLite scripts are very common in the wild and in the past we would simply error on dot commands like .read and .print, causing spurious warnings and an inability to format files like this properly. Now, these lines will be silently…