[Create a VIEW][1] explicitly naming the columns you want to consume. Then do `SELECT *` on the view. (This doesn’t contradict my post #5 in this thread, since you’re explicitly naming your columns in the first step.) [1]: https://sqlite.org/lang_createview.html