Cs Cart 4.3.6 And Mysql 8

Migrating to a new webserver and based on the documentation not showing there would be any issues, I installed MySQL 8.0.23 But now I am getting an error in admin, manage products because one of the select statements uses 'groups' which is now a restricted keyword. Anyone know of a simple solution to have MySQL run in some sort of a compatible mode?

SELECT COUNT(DISTINCT pf.feature_id) FROM cscart_product_features AS pf LEFT JOIN cscart_product_features AS groups ON pf.parent_id = groups.feature_id LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' WHERE 1 AND pf.feature_type != 'G' AND pf.feature_id NOT IN (0, 1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 17, 22, 24)

4.3.6 is pretty much ancient (2016)

For many reasons, you should upgrade to latest cs-cart

Or you can use an older version of mysql, that keyword reservation was added in 8.0.2