there's nothing stopping you from just executing the SQL directly.
I've never actually heard of CREATE TABLE AS before, but I just
checked it out and you can certainly generate the SQL programmatically
from a select, by inspecting each column in the select statement's c
collection.
On Tue, Jan 27, 2009 at 14:31, Michael Bayer mike...@zzzcomputing.com wrote:
there's nothing stopping you from just executing the SQL directly.
I've never actually heard of CREATE TABLE AS before, but I just
checked it out and you can certainly generate the SQL programmatically
from a
I found this to be an interesting little problem. The task can be
accomplished by using the text of a statement to construct a new
string then executing.
Here is a simple recipe using SQLite. I'm sure it can be extended
fairly easily, and should work in any standard SQL environment
import