sqlalchemy_multiinsert.py

from sqlalchemy import create_engine, MetaData, Table, Integer, Date, Column
import sqlalchemy.sql as sql

engine = create_engine("sqlite://")
md = MetaData(bind=engine)
table = Table("data", md)
table.append_column(Column("id", Integer))
table.append_column(Column("adate", Date))
table.append_column(Column("value", Integer))

data = [
  {"id": 1, "value": "foo", "adate": sql.func.now()},
  {"id": 2, "value": "bar", "adate": sql.func.now()}
]

print str(table.insert().values(data))