Recipes from Python SQLite docs

While going through the documentation of Python's sqlite31 module, I noticed that it's quite API driven, where different parts of the module are explained in a prescriptive manner. I, however, learn better from examples, recipes, and narratives. A few good recipes already exist in the docs, but I thought …