SQLite and 'WITH...'

Hello,
Is it possible to use a request like “WITH RECURSIVE…” with Xojo ?
If so, an example would be welcome.
Thanks

yes

In the sqlite docs you can find select with examples
https://sqlite.org/lang_with.html

On stackoverflow there you find more about it

In the dojo docs you find examples on how to use any kind of SQL statements in code
http://documentation.xojo.com/index.php/Database.SQLSelect

Tanks.

I will test