JOIN query produce unexpected problem

[EateralSpirial]

condition_1: select in : 'SELECT table_1 a LEFT JOIN table_2 b ON a.id = b.id WHERE ...' same with 'USING(id) '
condition_2: set "cursor_cls": asyncmy.cursors.DictCursor,
outcome python dictionary has a unexpected key: "b.id", which contains a unexpected dot: "." and will cause crush in most sql databases.