This isn't something one can actually recommend, right? It's not officially supported, probably not super well tested(?), could easily break at any point, won't

This isn't something one can actually recommend, right? It's not officially supported, probably not super well tested(?), could easily break at any point, won't work with various plugins/tools, etc. It'd be great of WordPress supported SQLite officially but I don't think I'd recommend this approach to anyone for a real site, even a personal one.