Yes it’s true that the group with SQL queries will fail and thus not execute. You’re right that we possibly could just ignore this and log null values, but for most situations where these are used, it probably wouldn’t be desirable. To put it a different way, groups have always worked more or less under the assumption that everything should completely successfully or not, and the general thought is that we don’t know how important that value is going to be.
Of course, the easy solution would just be to make an item level option that says “abort group execution on error”, so if it were set to false, it would just affect the item and not the group. This idea has been brought up before, but has not yet made its way into Ignition.
Regards,