SQLite Forum

Bug report: Complex CTE generates segmentation fault depending on the order of joined tables in its body
Login
Chronological Hierarchical 
> How effective would it be to provide the query planner with estimatedRows hints?

I don't know.  Why don't you try it and report back?