This was discovered in the guidance given after the MySQL 8.4 upgrade in the dev environment. There are some MySQL "reserved" words that should be avoided for table names because of potential conflicts, confusion, and syntax errors for other developers or future system upgrades. One of these table names is "groups" which we have in our gear_acl schema.
I think we should rename this table and all references to it as "roles" instead of "groups".