Add \SQL2Func\inTransaction to Default Queries
It looks like this, but with an return-handler:
-- name: \SQL2Func\inTransaction
-- Return true, if we are in an active Transaction and false if not
SELECT transaction_timestamp() != statement_timestamp()