Richard, thank you for your reply. I really appreciate it. The fact that you have carefully thought about how to cross the FROM clause barrier with expressions is itself a useful fact. If you say the current implementation is painted into a corner on this issue I believe you. It would be impossible to deduce this fact by simply studying documentation or source code. Thank you very much for taking my question.
At some point I may try what you suggest and see what I can learn. In the meantime, the CSV virtual table example appears to be closest to where I'd like to go next. https://sqlite.org/csv.html That example allows the caller to specify a creation schema. Expanding on the schema specifier, perhaps there is a way to make xBestIndex() and xFilter() work more generally in the problem domain of lightly encapsulated dynamic tables. On Sun, Mar 26, 2017 at 11:44 AM, Richard Hipp <d...@sqlite.org> wrote: > On 3/25/17, petern <peter.nichvolo...@gmail.com> wrote: > > > > Why can't we have a parallel syntax branch for scalar valued > > "table-naming-function-name"? In other words, why not have support for > > simply naming an existing table or view by return value of a scalar > > function? > > > > The easiest way for me to answer this is to ask you to provide a > sample implementation. After you've work on the problem for a while, > I think you will begin to understand why it is not possible. I can't > seem to come up with words to help make that realization any easier. > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users