Abort QSqlQuery::exec()

[elmo]

However, aborting a thread is not recommended, as the documentation states:

I read about terminating a thread and it's not something I'm going to consider as long as I'm sure it's safe to do (and I probably won't be with QSqlQuery::exec()).

However, if you're not going to abort the query very often, you may try with terminate()

Unfortunately I'm going to kill them fairly often.

keeping in mind it's risky and it can produce crashes, memory leaks and so on. I'm using terminate() in my application and it's working fine but I normally don't need to call it, it's a last-resort.

For me it's not even a last resort. For me it's unacceptable to write application in a way it allows situations in which application may crash (in theory memory leaks lead to using up all memory, so it's also a thing leading to crash).