This demonstrates how json_each() will overwrite a resulting row's id column, and how to retrieve the actual rowid. It does mention that: "The "id" column is an integer that identifies a specific JSON ...