How to perform a recursive query

[GodL]

Given a tree-like folder structure where each folder contains subfolders and files, how can we count all files under a specific folder?

[mbrandonw]

Hi @GodL, this can be done with what are known as "common table expressions" (CTE), and SQLite has a lot of docs on this here. StructuredQueries has full support for CTEs and has docs of its on this topic, and further the test suite has many examples.

Play around with that a bit and let us know if you have concrete questions afterwards.