Aha… I see… well… if that mysterious sponsor is familiar with ‘connect by’ they should have no issue with a recursive ‘with’ clause syntax, which is what Oracle provides now.
See "Recursive Subquery Factoring” in Oracle’s very own documentation: http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_10002.htm#SQLRF55268 http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_10002.htm#SQLRF55227 On Jan 8, 2014, at 8:03 PM, Richard Hipp <d...@sqlite.org> wrote: > That branch is a "sponsored" change. We are in communication with the > sponsor asking if they will consider WITH RECURSIVE syntax. Their original > request specified Oracle10g-compatible CONNECT-BY syntax. It depends on > what the sponsor really wants. (We await their reply.) > > The code will only make it into trunk if the sponsor selects WITH RECURSIVE. > > > On Wed, Jan 8, 2014 at 1:33 PM, Petite Abeille > <petite.abei...@gmail.com>wrote: > >> Hello, >> >> Couldn’t help but notice a brand new branch in SQLite’s repository, the >> one labeled "Start a new experimental branch for support of Oracle-style >> CONNECT BY syntax.”. >> >> http://www.sqlite.org/src/info/4365ddd62d >> >> Two reactions: >> >> (1) Recursive queries! Yes! Hurray! :D >> >> (2) CONNECT BY syntax?!? What the…!!! To paraphrase Ridley Scott: “On the >> interweb, no one can hear you scream.” >> >> If you are considering a syntax for recursion... please, please, pretty >> please, use Common Table Expression. Even Oracle does use it now. >> >> "Common table expressions are supported by DB2, Firebird, Microsoft SQL >> Server, Oracle (with recursion since 11g release 2), PostgreSQL (since >> 8.4), HyperSQL and H2 (experimental).”. >> >> http://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL >> >> Let have SQLite added to that list :)) >> >> >> >> >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users