diff options
| -rw-r--r-- | doc/build/changelog/changelog_08.rst | 4 | ||||
| -rw-r--r-- | doc/build/changelog/migration_08.rst | 24 |
2 files changed, 28 insertions, 0 deletions
diff --git a/doc/build/changelog/changelog_08.rst b/doc/build/changelog/changelog_08.rst index 002eaf704..6515f731d 100644 --- a/doc/build/changelog/changelog_08.rst +++ b/doc/build/changelog/changelog_08.rst @@ -2156,6 +2156,10 @@ Supported by Postgresql, SQLite, and MySQL. Big thanks to Idan Kamara for doing the legwork on this one. + .. seealso:: + + :ref:`feature_2623` + .. change:: :tags: oracle, bug :tickets: 2620 diff --git a/doc/build/changelog/migration_08.rst b/doc/build/changelog/migration_08.rst index 717a24c73..fd153a925 100644 --- a/doc/build/changelog/migration_08.rst +++ b/doc/build/changelog/migration_08.rst @@ -683,6 +683,30 @@ as more string, integer and date operators. :ticket:`2547` +.. _feature_2623: + +Multiple-VALUES support for Insert +----------------------------------- + +The :meth:`.Insert.values` method now supports a list of dictionaries, +which will render a multi-VALUES statement such as +``VALUES (<row1>), (<row2>), ...``. This is only relevant to backends which +support this syntax, including Postgresql, SQLite, and MySQL. It is +not the same thing as the usual ``executemany()`` style of INSERT which +remains unchanged:: + + users.insert().values([ + {"name": "some name"}, + {"name": "some other name"}, + {"name": "yet another name"}, + ]) + +.. seealso:: + + :meth:`.Insert.values` + +:ticket:`2623` + Type Expressions ----------------- |