I break it down two ways.
First, the project does not yet have a distributed implementation, you’re correct. Stay tuned!
Second, SQLite is incidental. Data is still stored on disk, just as SQS must be, but I’ve chosen SQLite as the file format for now.