[Sqlalchemy-users] INSERT INTO SELECT FROM

[Rick Morrision]

Does anyone know a quick way to pull off "INSERT INTO SELECT FROM" in SA?

I knew it probably wouldn't work, but I tried the naive:

         T1.insert().execute(db.sql.select([T2.cols]))

and it, uh, doesn't work.

<'Select' object has no attribute 'get'>

Can selectables be used as input to .insert(), or am I just phrasing this wrong ?

Thanks,
Rick