Is there a way to get results out of a transaction?

[fmv1992]

Is there a way to use transactions and get results out of it?

esqlite3:q(
<<"
BEGIN;
-- SELECT data from blobs where md5sum = ?;
-- INSERT INTO blobs_access_record (md5sum) values (?);
SELECT 1;
SELECT 1;
SELECT 1;
COMMIT;
">>,
[],
Db)

Returns []. I would like to get the [1,1,1].

[mmzeeman]

I think the only way to do that is using multiple queries.

[mmzeeman]

Ah... after inspecting the sqlite3 c api, I think it should be possible to support this. I will look into this. Only not with prepared statements which can take parameters.