ERROR:SQL When loading groups

During mangosd startup I noticed the following sql error in the log:

2018-09-23 20:57:23 ERROR:SQL: SELECT group_instance.leaderGuid, instance FROM group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL
2018-09-23 20:57:23 ERROR:query ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS' at line 1

I am runnig on MySQL 8.0.

It seems like the table name "groups" is a reserved word in MySQL 8.0 so the query fails.

https://forums.mysql.com/read.php?101,665004,665004

( 'GROUPS', 'Reserved', 'added in 8.0' ), 

EDIT:

Seeing the a similar issue here:

2018-09-23 20:57:24 Loading Spell Chain Data...
2018-09-23 20:57:24 ERROR:SQL: SELECT spell_id, prev_spell, first_spell, rank, req_spell FROM spell_chain
2018-09-23 20:57:24 ERROR:query ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', req_spell FROM spell_chain' at line 1

The word "rank" is also reserved in MySQL 8.0

( 'RANK', 'Reserved', 'added in 8.0' ), 

This query seems to work if you use an alias for the table name

SELECT spell_id, prev_spell, first_spell, sc.rank, req_spell FROM spell_chain as sc