I'm experimenting today with WordLand running with SQLite instead of MySQL. Nothing to show yet, but it works for me locally with a small patch to the wordland repo.
SQLite is progress. When you're ready tell us how you did it. I assume it's being done at the wpidentity level?
I don't know about wpIdentity but rss.voice uses D1 which is a SQLite database. You can see how it's used in this file. Just find "env.DB.prepare" calls.
https://github.com/donpark/rss.voice/blob/main/apps/server/src/index.ts