To me, the only thing that *really* makes SQLite a *completely* different animal is its dynamically typed columns
That makes it a good fit for dynamically typed languages, and if I can get those any/blob conversions going (ASN.1 Lisp Encoding Rules, <
http://tinyurl.com/asn1-ler>) then it becomes plausible to store just about everything there modulo procedures and ports.
Single file zero-admin is a different beast administratively, that should make you much more prone to use it,
Not only that, but "SQL-queryable table" is a data structure that (like vectors, sets, multi-dimensional arrays, etc.), every Scheme programmer should be able to put their hands on at any time, independent of whether a given table is persistent or not.