The documentation will have to show people how to use these with json_each(). Here's a neater example query (it's easier to imagine how you might join this against other tables) (see original)
Originally posted by @simonw in #1 (comment)