You might be able to make transactions work but it's really the opposite of what duckdb is designed for. Do it only for fun.