Does the execute query activity lock the database while reading?
It seems to be very picky and not want to accept anything but select statements.
If possible, I would like to make them uncommitted reads, as I have an orchestration set up to do parallel processing, so it's possible many execute queries could be happening at the same time.
I'd want to put something like:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED