SQLite makes for a really nice document store with the json arrow functions. Assume you have a "book" column that is a json blob, then selecting the names of al

SQLite makes for a really nice document store with the json arrow functions. Assume you have a "book" column that is a json blob, then selecting the names of all books is just: SELECT book->>'name' FROM books; The only thing I miss is auto increments. Without an additional "id" column, inserting a new book with a unique id becomes cumbersome.