Comment by igalklebanov

it depends on the database. the major ones support savepoints. postgres included. https://www.postgresql.org/docs/current/sql-savepoint.html https://dev.mysql.com/doc/refman/8.4/en/savepoint.html https://learn.microsoft.com/en-us/sql/t-sql/language-element... https://sqlite.org/lang_savepoint.html

in kysely, the dialect you're using has to implement the new optional savepoint-specific methods for it to work.