Contents1Ancestors2Descendants3To Do’sAs of Feb 3, 2014 and version 3.8.3, SQLite introduced “Recursive common table expressions (that) provide the ability to do hierarchical or recursive queries of trees and graphs, a capability that is not otherwise available in the SQL language”. (http://www.sqlite.org/lang_with.html) This means it is now possible to generate ancestry or descendancy lists within SQLite, … Continue reading Recursive Queries – Ancestors and Descendants #recursive #ancestors #descendants