Add C bindings for transaction support #2168
Description
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
{{ message }}