SQLAlchemy - INSERT INTO ... (SELECT ...)

gistfile1.py

from sqlalchemy.sql.expression import Executable, ClauseElement


class InsertFromSelect(Executable, ClauseElement):
    _execution_options = \
        Executable._execution_options.union({'autocommit': True})

    def __init__(self, table, columns, select):
        self.table = table
        self.columns = columns
        self.select = select


@compiles(InsertFromSelect)
def visit_insert_from_select(element, compiler, **kw):
    return "INSERT INTO %s (%s) (%s)" % (
        compiler.process(element.table, asfrom=True),
        ", ".join([col.name for col in element.columns]),
        compiler.process(element.select)
    )