Re: Creating database tables from queries based on ORM API?

On Sat, Apr 13, 2019 at 06:19:40PM +0200, Markus Elfring <[email protected]> wrote:
> >> Can the support be improved for the command variant ???CREATE TABLE AS SELECT??? (CTAS)
> >> in this software area?
> >
> >    How would you write that in Python?
> 
> It could be written already if such a SQL command would be submitted to
> a direct database programming interface.
> This software situation can look different if there are additional
> abstractions involved because of object-relational mapping.
> Can a query object be passed as a parameter for a corresponding method call?

   Certainly. Both SelectResults[1] and SQLBuilder[2]'s objects
can be passed, they're just Python objects, no magic.

1. http://sqlobject.org/SelectResults.html
2. http://sqlobject.org/SQLBuilder.html

> Regards,
> Markus

Oleg.
-- 
    Oleg Broytman            https://phdru.name/            [email protected]
           Programmers don't die, they just GOSUB without RETURN.