Query is not cancellable during long CodeGen

Running TestExprLimits::test_under_statement_expression_limit with codegen enabled will result in long codegen compilation time. Such query is not cancellable/closeable until codegen is finished. Backend should check for query cancellation in-between codegen compilation.