Steps to reproduce the issue

I am updating my J3 component to J4 and have come across a major problem
and example of my query.
$query->select($db->quoteName(array('r.rid' , 'e.id', 'r.firstname', 'r.lastname', 'r.email', 'e.titel', 'l.club', 'l.url', 'l.city',
'l.plz', 'l.street', 'l.country', 'l.locdescription','e.status', 'e.email_reminder', 'e.dates', 'e.times',
'e.enddates', 'e.endtimes', 'e.shortdescription', 'e.datdescription'),array('uid','eid',null,null,
null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null)))
->from($db->quoteName('#__registrationmanagerking_events','e'))
->from($db->quoteName('#__registrationmanagerking_locate','l'))
->from($db->quoteName('#__registrationmanagerking_register','r'))

->where($db->quoteName('r.notified') . ' =0 ','and')
->where($db->quoteName('r.status') . ' =1 ','and')
->where($db->quoteName('e.id') . ' = '.$db->quoteName('r.rdid'),'and')
->where($db->quoteName('l.id') . ' = '.$db->quoteName('e.locid'),'and')
->where($db->quoteName('e.published') . ' =1 ','and')
->where($db->quote($current_date) .'>= DATE_SUB(e.dates ,INTERVAL e.notifydate DAY)','and')
->where($db->quoteName('e.notifydate') . ' !=0 ','and')
->where($db->quoteName('e.status') . ' !=2 ')
    ->group($db->quoteName('r.rid'));

I ONLY want to group by r.rid and nothing else.
Joomla! 4 requires me to add ALL the fields in my field select list, in the group clause.
I can see this in the core components, but I think this is VERY wrong.
Not only is it wrong, but it will stop almost EVERY Joomla! commercial and free component from working.
It seems very Unnecessary to have made this change.

Expected result

Actual result

System information (as much as possible)

Additional comments