Bad input of "group by" accepted

[hunhoffe]

Describe the bug

I have a (very inefficient) constraint that looks something like this:

    final String APP_CORE_LIST_VIEW =
            "create constraint app_colocation as \n" +
                    "select applications.id as app, processes.controllable__core as core " +
                    " from applications join processes on applications.process_id = processes.id " +
                    "group by applications.id, processes.controllable__core";

It's come to my attention that this type of constraint should not be allowed.

Reproduction steps

1. Try to create a minimal example
2. If the minimal example fails, ask Erika for her (very very messy) minimal example
3. Reproduce using the repo Erika will give you access to
...

Expected behavior

The constraint is accepted without error.

Additional context

No response