/sql endpoint transactions

Hi

I was reading this post: Serverless Driver for Java

Is there doco available for the /sql API endpoint?

I'm trying to understand how to create a serializable transaction containing a SELECT and an INSERT where the latter depends on the result of the former. Is this possible with the /sql API?

Thanks

Ben