"I'd really love some kind of distributed-for-performance database using the exact optimizer and query planner of SQLite plus std plugins..."
Why do you think the identical optimizer and query planner would work in a distributed environment, with no changes from the single server implementations?