I believe you can do this even without the `closure` extension, using standard SQL `with recursive`.
https://sqlite.org/lang_with.html#recursive_common_table_exp...
https://sqlite.org/lang_with.html#recursive_common_table_exp...
In the end, he compares five hierarchical data designs. Unsurprisingly, all have pros and cons and it is a (somehow advanced) matter of picking the right tool for the job. Closure tables may in fact be the lesser know variant, adjacency lists and recursive queries one of the better knows. But there are also path enumerations and nested sets.