Cancel can not be done except if the query is not split into chunks using offset/limit. Then a check for a Cancel click will be performed in the time between retrieving every chunk.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Cancel can not be done except if the query is not split into chunks using offset/limit. Then a check for a Cancel click will be performed in the time between retrieving every chunk.