it depends on the database. the major ones support savepoints. postgres included. https://www.postgresql.org/docs/current/sql-savepoint.html https://www.postgre

it depends on the database. the major ones support savepoints. postgres included. https://www.postgresql.org/docs/current/sql-savepoint.html https://www.postgresql.org/docs/current/sql-savepoint.html https://dev.mysql.com/doc/refman/8.4/en/savepoint.html https://dev.mysql.com/doc/refman/8.4/en/savepoint.html https://learn.microsoft.com/en-us/sql/t-sql/language-elements/save-transaction-transact-sql?view=sql-server-ver16 https://learn.microsoft.com/en-us/sql/t-sql/language-element... https://sqlite.org/lang_savepoint.html 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.