For context, before the rise of SQLite, BerkeleyDB was often used for local file databases.
I never programmed for berkelyDB but I don’t believe it was SQL, so I think that’s what made SQLite so successful. The combination of an SQL api backed by local files