The C API currently lacks transaction support.

Adding libsql_tx with begin/commit/rollback/free functions is needed so SDKs (like the C# client) can implement proper transaction handling